Thread: Command bar
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MaC MaC is offline
external usenet poster
 
Posts: 13
Default Command bar

If you've got your own menu or toolbar, then just you can disable Excel main
menu bar like this:

Application.CommandBars("Worksheet Menu Bar").Enabled=FALSE

To switch it on again use:

Application.CommandBars("Worksheet Menu Bar").Enabled=TRUE

HTH
MarioC


Użytkownik "Fisker" napisał w wiadomości
...
Hi,

How do I hide or disable the "save" command in the "File" menu for a
workbook, so I ensure that changes will not be saved in the "template".
--
Fisker