Thread: Lock sheet tabs option in a specific workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Lock sheet tabs option in a specific workbook
Have you try my answer in your other thread

You can disable Options in the Tools menu

Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=522, Recursive:=True).Enabled = False

See also
http://www.rondebruin.nl/menuid.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tarique" wrote in message ...
I want to Lock sheet tabs option in a specific workbook / worksheet & not for
all workbooks.


Reply With QuoteReply With Quote