View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Hide/Delete XL Menus

Would this work for you?

With Application
.DisplayFullScreen = True 'False
.CommandBars(1).Enabled = False 'True
End With

--

Vasant

"Rockee052 " wrote in message
...
Hello,

I am trying to delete or hide all of excels menus (not sure what the
best method would be). I have a few custom menus that I would like to
keep. I have played around with Application.CommandBar(2).Visible =
False, but this will obviously take me a long time to complete. I was
wondering if anyone knows of a simpler way to hide or delete the built
in menus upon opening a workbook, then before closing restore the
menus, that way I won't mess up every workbook. I have looked in VBE
help but, that's whole other story. I have also looked in google but,
my search skills are limited . So, if anyone has any suggestons
or a link to a website that may help me. I would really appreciate
it... Thanks

Rockee
Excel 2003


---
Message posted from http://www.ExcelForum.com/