Hiding Menu Bar With Macro Command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zainuddin Zakaria - 20 Dec 2006 17:19 GMT

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

Reply to this Message

Ron de Bruin - 20 Dec 2006 17:41 GMT

Hi Zainuddin

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

Signature

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

> Hi all,
> Can someone help me with a 'macro script' on how to hide a Menu Bar
[quoted text clipped - 3 lines]
>
> Zainuddin Z

Reply to this Message

Gord Dibben - 20 Dec 2006 19:37 GMT

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

>Hi all,
>Can someone help me with a 'macro script' on how to hide a Menu Bar
[quoted text clipped - 3 lines]
>
>Zainuddin Z

Reply to this Message

Zainuddin Zakaria - 21 Dec 2006 07:30 GMT

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

> Hi all,
> Can someone help me with a 'macro script' on how to hide a Menu Bar
[quoted text clipped - 3 lines]
>
> Zainuddin Z

Reply to this Message

Gord Dibben - 21 Dec 2006 16:43 GMT

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.
>
[quoted text clipped - 5 lines]
>>
>> Zainuddin Z

Gord Dibben MS Excel MVP

Reply to this Message