Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sylvia
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy worksheet to another workbook jtaiariol Excel Discussion (Misc queries) 5 January 1st 06 06:32 PM
Customizing Worksheet Menu Bar question. Help! [email protected] Excel Discussion (Misc queries) 0 October 26th 05 02:28 PM
worksheet menu bar ditchy Excel Discussion (Misc queries) 4 May 4th 05 10:09 AM
Help - now really stuck! File transfer problem ohboy! Excel Discussion (Misc queries) 10 May 2nd 05 09:07 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"