re-enabling macro under menu item
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
|