hide menu bar
 

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

hide menu bar
 

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


"pswanie" wrote:

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

hide menu bar
 

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stephen C" wrote in message ...
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


"pswanie" wrote:

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