ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disabling specific items under tools menu (https://www.excelbanter.com/excel-programming/439924-disabling-specific-items-under-tools-menu.html)

michael.beckinsale

disabling specific items under tools menu
 
Hi All,

I know l can disable the 'Options' menu using code something like:

Application.CommandBars("Tools").Controls("Options ").Enabled = False

But what l would like to do is specifically disable JUST the following
choices on the View tab:

Row & column headers
Outline symbols

If somebody can pointme in the right direction / provide some sample
code that would br great.

TIA

Michael


All times are GMT +1. The time now is 09:46 PM.

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