Thread: How to disable the right click on the worksheet tab?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don P[_3_] Don P[_3_] is offline
external usenet poster
  
Posts: 1
Default How to disable the right click on the worksheet tab?
Thanks. It works fine.

"Ron de Bruin" wrote:

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