commandbar

  • Thread starter Thread starter Greg Prost
  • Start date Start date
G

Greg Prost

how would i go about removing the File, edit, view etc
menus from the top
 
Greg,

Use the following code to hide the menu bar. Change False to True to restore
the menu bar.

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide menus etc in Excel 2007 5
VB - Macro to list all controls in the Commandbar. 8
Context menu for chart is missing 1
auto enable macros 5
Works too well - Hide toolbar Macro 4
Stripping down excel 2
Code Crashing 3
menu bar and error 91 3

Back
Top