Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A few posts here provide me added knowledge. In one, it mentioned a way to disable "Print option under File", using
CommandBars("Worksheet Menu Bar").Controls("File").Controls("Print...").Enable d = Fals Suppose I open a new Excel file. Fire up macro editor and make up one macro with the following variant sub disableM( CommandBars("Worksheet Menu Bar").Controls("File").Controls("Print...").Enable d = Fals end su I save the Excel file as test.xls. Run the macro. It "works". The macro option has gone. But then how can I get my macro option back? I thought my 'macro option' will be back if I close Excel and reopen Excel. But no, the option doesn't come back. What is the simplest solution (to give the macro function back to the user) IF this was the case I am a little bit smarter than the dummies. I do not actually have such a problem because I "forsee" it. I did wrote an enableM() function together with my disableM() function under "test.xls". So what I did to resolve the problem is to enter the keyboard shortcut for enableM(). But IN CASE there wasn't such command, is there a simpler solution to reset the macro function back to life, without borrowing another pc to create an excel file with enableM() macro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling sub menu items via vba | Excel Worksheet Functions | |||
Enabling shortcut menu | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Disable File-Save menu item in macro? | Excel Programming | |||
Macro to display a menu item - possible? | Excel Programming |