Can you disable the sort option on the data menu on a particular worksheet? Thanks
Can you disable the sort option on the data menu on a particular worksheet? Thanks
Peace of mind is found in some of the strangest places.
[vba]
Application.Commandbars("Worksheet Menu Bar").Controls("Data").Controls("Sort...").Enabled = False
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks buddy. BTW, your code for the export of a userform is exactly what I wanted. Thanks
Peace of mind is found in some of the strangest places.
Glad to be of service mate!
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Peace of mind is found in some of the strangest places.
Presumably because you don't have a form with that name?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Peace of mind is found in some of the strangest places.
I see it now
Peace of mind is found in some of the strangest places.