hide menu bar

[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

 

[Guest]

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

 

[Ron de Bruin]

I have update the page on my NL site
Use this one
http://www.rondebruin.nl/menuid.htm

I will delete the page on the com site this week