Hi
If your code must work also in non English versions use
Sub test()
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=891, Recursive:=True).Enabled = False
End Sub
More info here
http://www.rondebruin.nl/menuid.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Mike H" wrote in message ...
Try this:-
Private Sub Workbook_Open()
With Application.CommandBars("Format")
With .Controls("&Sheet")
.Controls("&Unhide...").Enabled = False
End With
End With
End Sub
Remebering of course to to put the same routing in the before_close event
with false changed to true.
Mike
"contactf" wrote:
How to disable unhide sheet menu option. i dont want people to unhide hidden
sheets in my excel workbook