View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default worksheet tab - rightclick choices

It is

Commandbars("Ply")

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

Regards,
Tom Ogilvy


"Marc" wrote in message
...
To all:

I've spent considerable time trying to figure out a way to
disable the menu that popups up (insert, delete, rename,
select all sheets...) when you right-click a worksheet tab.

Can anyone explain how I can disable this right-click menu?

Any helpl would be much appreciated.

Thank you,
-Marc