ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   No right click on sheet tab (https://www.excelbanter.com/excel-programming/389319-no-right-click-sheet-tab.html)

Gordon[_2_]

No right click on sheet tab
 
Hi. I've disabled right clicking on my sheet but don't know how to disable
right click on the sheet tabs.

Any help appreciated...

G

Ron de Bruin

No right click on sheet tab
 
Hi Gordon

The name of the toolbar = Ply

You can use
Application.CommandBars("Ply").Enabled = False



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gordon" wrote in message ...
Hi. I've disabled right clicking on my sheet but don't know how to disable
right click on the sheet tabs.

Any help appreciated...

G



All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com