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
|