Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customizing Worksheet Menu Bar for a workbook without VBA coding
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy worksheet to another workbook | Excel Discussion (Misc queries) | |||
Customizing Worksheet Menu Bar question. Help! | Excel Discussion (Misc queries) | |||
worksheet menu bar | Excel Discussion (Misc queries) | |||
Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) |