Default Menu

[halem2]

Hello:
I have two questions..

1.- I need to display a different menu (File, Edit, VIew, ...) in
specific workbook and suppress the regular Excel menu only in thi
workbook.

I've suppressed the tool bars using

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

but I can't figure out the one for the Main Menu bar.

2.- Also they user still has the ability to right click on the too
bar area and select a tool bar. Is there a way to lock this down?

thanks

 

[Tom Ogilvy]

Application.CommandBars("Worksheet Menu Bar").Enabled = False

 

[halem2]

thanks Tom. That works fine for the Main Menu but the user still hav
the ability to right click on the tool bars and open any of them. I
there a way to lock them down to the one I select?

thank

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;170563&Product=xlw
OFF97: How to Prevent Customization of Menus and Toolbars