U_Shrestha
03-18-2008, 09:22 AM
Hello all,
I need help with following things:
1) In the menu bar, I need to display only 'File', and 'Help' Menu. Under 'File', I want to display only Open, Close, Save, Print, Print Preview, Exit. I want all other menu items hidden.
2) In the Toolbar, I want to display only "print preview", and 'print' only.
3) Most importantly, I want this feature only in a particular file, so that a user will see only these items in their Menubar and Toolbar but they would see their own Menubar and Toolbar in their other Excel files. I do not want this feature to affect any of their Excel application.
4) I want to create a keyboard Shortcut (Ctrl+M) or a commandbutton that will enable a default Menubars or the Toolbars in the same file by prompting for a correct password.
Can someone help me with this, or direct me where I can find this feature. Thanks.
I need help with following things:
1) In the menu bar, I need to display only 'File', and 'Help' Menu. Under 'File', I want to display only Open, Close, Save, Print, Print Preview, Exit. I want all other menu items hidden.
2) In the Toolbar, I want to display only "print preview", and 'print' only.
3) Most importantly, I want this feature only in a particular file, so that a user will see only these items in their Menubar and Toolbar but they would see their own Menubar and Toolbar in their other Excel files. I do not want this feature to affect any of their Excel application.
4) I want to create a keyboard Shortcut (Ctrl+M) or a commandbutton that will enable a default Menubars or the Toolbars in the same file by prompting for a correct password.
Can someone help me with this, or direct me where I can find this feature. Thanks.