Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
run procedure when exit design mode
Hi,
I have some procedures with static variables like "blnInitDone" to prevent a very large and time-consuming piece of code to run more than once. These procedures are typically called when opening the workbook. Now every time I enter and exit design mode, these variables lose their value so the large piece of code gets run again (which isn't necessary). Is there any way to make a procedure run automatically whenever I exit design mode as to initialise the values correctly? Or to link a macro to the "Exit Design Mode" button (but then I guess you have to be able to determine whether you're already in desing mode or not, otherwise the macro also gets run when you enter design mode...) Thanks. -=Wim=- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
run procedure when exit design mode
Oops - I reposted this one in "Excel Programming" because it shouldn't have
been posted here... It's not a General Question. Please reply to the other post. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is Design Mode in Excel? | Excel Discussion (Misc queries) | |||
Error Msg "Can't Exit Design Mode" | Excel Discussion (Misc queries) | |||
I can't exit from Design mode anymore | Excel Discussion (Misc queries) | |||
What is procedure to exit formula auditing mode? | Excel Discussion (Misc queries) | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |