View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default 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