hide menu bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey...

i need to add a code to a existing macro that i got. the macro let me go to
a spesific worksheet.

at the start of that macro i need to disable "standard, formating, drawing"
etc

when u right click on eg. file and take the "tick" mark out of eg. standard
and formating and drawing.

and then i got a macro that save and quit the workbook. with that i then
need to add a code to enable those again
 
Hi

To hide

Application.CommandBars("Standard").Enabled = False

Application.CommandBars("Formatting").Enabled = False

Application.CommandBars("Drawing").Enabled = False

To show

Application.CommandBars("Standard").Enabled = True

Application.CommandBars("Formatting").Enabled = True

Application.CommandBars("Drawing").Enabled = True


Check out http://www.rondebruin.com/menuid.htm#Information
 
Back
Top