Thread: How to disable the right click on the worksheet tab?
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 How to disable the right click on the worksheet tab?
Hi Don

This menu is named Ply

Application.CommandBars("Ply").Enabled = False



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


"Don P" <Don wrote in message ...
I would like to disable the delete option from the tab right click menu so
that the worksheet can not be deleted.

Thanks
Don


Reply With QuoteReply With Quote