Hi guys!
Introduction:
First of all thank you for your high activity on this Forum - I've already found numerous solutions to problems I encountered during coding of my macros. However today the search function of the Forum+Google didn't provide me with a solution.
Problem:
I have an Excel Macro which gets a userinput through _MouseDown events. After the macro has reached the end of the main Sub, it apparantly finishes the code, but the "run macro (F5)" button stays gray and I cant click it. Also I can't click on the dropdown menues "File, Edit, View", but reach them via shortcut (pressing alt + keyboard).
The button "run macro (F5)" doesnt work, but if I hit F5, the macro runs again from the start. Pressing the "Stop button" resets everything as normal.
Funny: If I set a break point at the last line End Sub and resume after breaking, everything is fine ("Run Macro Button" ist green). The same happens, if I insert an
Statement right before End Sub. This behaviour is really strange and I don't understand it.
Misc:
Restarting Excel/VBA/PC didn't help.
Does anyone have any idea on this? So far it's not really a problem, since I simply put End at the end of my code, but I don't really like working around the problem.
Introduction:
First of all thank you for your high activity on this Forum - I've already found numerous solutions to problems I encountered during coding of my macros. However today the search function of the Forum+Google didn't provide me with a solution.
Problem:
I have an Excel Macro which gets a userinput through _MouseDown events. After the macro has reached the end of the main Sub, it apparantly finishes the code, but the "run macro (F5)" button stays gray and I cant click it. Also I can't click on the dropdown menues "File, Edit, View", but reach them via shortcut (pressing alt + keyboard).
The button "run macro (F5)" doesnt work, but if I hit F5, the macro runs again from the start. Pressing the "Stop button" resets everything as normal.
Funny: If I set a break point at the last line End Sub and resume after breaking, everything is fine ("Run Macro Button" ist green). The same happens, if I insert an
Code:
End
Misc:
Restarting Excel/VBA/PC didn't help.
Does anyone have any idea on this? So far it's not really a problem, since I simply put End at the end of my code, but I don't really like working around the problem.