Hiding Menu Bar With Macro Command

[Zainuddin Zakaria]

Hi all,
Can someone help me with a 'macro script' on how to hide a Menu Bar
(File/Edit/View/Insert/Format etc).
I just want to block people from using the functions in Menu bar.
Thank you so much.

Zainuddin Z

 

[Ron de Bruin]

Hi Zainuddin

Start here
http://www.rondebruin.nl/menuid.htm

 

[Gord Dibben]

Copy these to your Thisworkbook module.

Private Sub Workbook_Open()
Application.CommandBars("Worksheet Menu Bar").Enabled = False
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub

Right-click on the Excel logo left of "File" and select "View Code".

Copy/paste into that module.


Gord Dibben MS Excel MVP

 

[Zainuddin Zakaria]

Thanks Gord Dibben. I have got it. You are really an expert.

 

[Gord Dibben]

Must be Christmas season.

Everyone is getting generous with the praise<g>

Thanks for the feedback

Thanks Gord Dibben. I have got it. You are really an expert.

Gord Dibben MS Excel MVP