If you want to take out that control then use
Application.CommandBars("Worksheet Menu
Bar").Controls("Format").Controls("Sheet").Control s("Unhide...").Enabled =
True
but if you just want to stop a user unhiding one of your sheets, you can
make it very hidden, which means the user won't see it in the list of hidden
sheets a better way IMO)
Worksheets("mySheet").Visible = xlSheetVeryHidden
--
HTH
RP
(remove nothere from the email address if mailing direct)
"ditchy" wrote in message
oups.com...
Hello
is there a way to dis-able the unhide sheets toolbar?
TIA, Ditchy
|