PDA

View Full Version : Solved: Disable an option in a menu



austenr
08-16-2007, 11:14 AM
Can you disable the sort option on the data menu on a particular worksheet? Thanks

Bob Phillips
08-16-2007, 11:19 AM
Application.Commandbars("Worksheet Menu Bar").Controls("Data").Controls("Sort...").Enabled = False

austenr
08-16-2007, 11:21 AM
Thanks buddy. BTW, your code for the export of a userform is exactly what I wanted. Thanks

Bob Phillips
08-16-2007, 11:42 AM
Glad to be of service mate!

austenr
08-16-2007, 11:45 AM
One other thing. On the export userform code you gave me, if I try to run it I get a subscript out of range error.

Bob Phillips
08-16-2007, 01:02 PM
Presumably because you don't have a form with that name?

austenr
08-16-2007, 01:14 PM
:banghead: :dau:

austenr
08-16-2007, 01:14 PM
I see it now