MrExcel.com - Your One Stop for Excel Tips & Solutions

Worksheet Menu Bar

Posted by Roy on August 18, 2001 3:35 AM

I recorded a macro to hide worksheet menu bar but when i input into my code it gives an error

Anyone know the code i need to use to get this to work

Thanks
Roy

Posted by Paul on August 19, 2001 10:36 AM

application.commandbars("Worksheet menu bar").controls(6).delete

this deletes the 6th item from the left ( usually "tools" )

Application.CommandBars("Worksheet Menu Bar").Reset

Resets the tool bar

Play with this if it helps