Solved: Disable an option in a menu

[austenr]

Can you disable the sort option on the data menu on a particular worksheet? Thanks

[Bob Phillips]

Application.Commandbars("Worksheet Menu Bar").Controls("Data").Controls("Sort...").Enabled = False

[austenr]

Thanks buddy. BTW, your code for the export of a userform is exactly what I wanted. Thanks

[Bob Phillips]

Glad to be of service mate!

[austenr]

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]

Presumably because you don't have a form with that name?

[austenr]

:banghead: :dau:

[austenr]

I see it now