Customizing Worksheet Menu Bar for a workbook without VBA coding

S

Sylvia

Hi All,

I have this workbook which was upgraded from previous version of Excel.

Whenever I open the workbook, it will hide all the menu (Edit, View,
Insert, Format, Tools, Data, Window, Help) in the worksheet menu bar
(except the File menu). Certain items (eg. Save and Save as) in the
file menu are also hidden.

When I close the workbook, the worksheet menu bar is reset.

I have read in most websites that this can be done via vba macro.
However, when I look into this particular workbook, there are no macros
attached.

Also, there are no custom menu on the workbook.

I'm wondering if anyone knows how the Worksheet Menu bar can be
customized without any macro and only affects the workbook that it is
assigned to.

Please advice how this can be done.


Regards,
Huey Yee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing items in the menu bar 1
Menu Macro Not Executing - Need Help 1
VBA Coding Help for Beginner 0
VBA for Dependents shortcut menu 0
Save workbook without shapes 0
Need Help with Macro Security 1
Customizing Excel Worksheet Menu Bar without VBA coding 8
VBA to do a mailmerge from a Specific Excel worksheet 0

Top