Worksheet Menu Bar Removal

[Muratti]

Is there any way to remove the Worksheet Menu bar (file, edit, tools etc.) from the excel and save it without it, so when the user opens it, it would not have the menu bar. Thanks.

[philipjsmith]

Go to http://www.ozgrid.com & there is some VBA code on the link to Worksheet Events that will remove all toolbars. I would guess that it could be modified to remove just ONE toolbar.

On 2002-05-20 14:22, Muratti wrote:
Is there any way to remove the Worksheet Menu bar (file, edit, tools etc.) from the excel and save it without it, so when the user opens it, it would not have the menu bar. Thanks.

[sen_edp]

hello

Yes there is a way to hide the worksheet menu bar.You go to the menu,view,toolbars,customize,toolbars , and uncheck the worksheet menu bar.

or

You can do it by inserting a vba sub like this and run it once
Sub hidemenubar()
CommandBars("Worksheet Menu Bar").Enabled = False
End Sub


_________________
Best Regards,
Andreas
using Excel 2000 - Windows 2000 prof.

[ This Message was edited by: sen_edp on 2002-05-20 14:43 ]