ExcelBanter - How to disable the right click on the worksheet tab?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to disable the right click on the worksheet tab? (https://www.excelbanter.com/excel-programming/358505-how-disable-right-click-worksheet-tab.html)

Don P[_2_]

How to disable the right click on the worksheet tab?

I would like to disable the delete option from the tab right click menu so
that the worksheet can not be deleted.

Thanks
Don

Ron de Bruin

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

Don P[_3_]

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

All times are GMT +1. The time now is 06:14 AM.