View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Benijofar Dave[_2_] Benijofar Dave[_2_] is offline
external usenet poster
 
Posts: 1
Default protecting sheet tabs

Should this work in 2003 if so where should it be placed, thanks in advanvce.

"Tom Ogilvy" wrote:

to the best of my knowledge, this is not something you can prevent.

Removing the options menu seems a little drastic, but

Application.Commandbars("Tools").Controls("&Option s...").Visible = False

--
Regards,
Tom Ogilvy




"Mike" wrote:

I don't think this helps because I'm not trying to hide the sheet. What I'm
trying to do is hide the sheet tab only and stop users un-hiding the tabs