View Single Post
  #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