LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sylvia
 
Posts: n/a
Default Customizing Excel Worksheet Menu Bar without VBA coding

Dear All,

I'm puzzled by an Excel Workbook file which was handed over to me by an
ex-colleague.

The workbook has a customized worksheet menu bar.
When you open the workbook, it will hide the Edit, View, Insert,
Format, Tools, Data, Window, Help menu and the Save and Save As
sub-menu in the File Menu.

When you close the workbook, the worksheet menu bar will be reset and
all the menus are available again.

I know that this can be done using macro, but I couldn't find any
macros attached to this file.

When I open the file and disable the macro, the worksheet menu bar
still gets customized.

I tried to look for custom menu bar in the workbook, but couldn't find
any as well.

Does anybody has any idea how the above mentioned can be done?

I would be glad to share the workbook as long as I can get an answer.

Thank you.

Regards,
Sylvia

 
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
How can I protect a worksheet yet allow editing in Excel 2000 jimar Excel Discussion (Misc queries) 1 August 26th 05 11:25 AM
exporting excel worksheet to word morrowkd Links and Linking in Excel 1 May 11th 05 11:23 PM
right click menu excel Jo Vercauteren New Users to Excel 1 May 3rd 05 09:34 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 07:12 PM


All times are GMT +1. The time now is 08:10 PM.

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

About Us

"It's about Microsoft Excel"