Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with worksheet_deactivate code
I've got a userform that opens when a sheet is active and is supposed to
close when the same sheet is deactivated. This has worked fine in the past and I was wonder what if anything can be done. what happens now? It opens and closes normally until a button on the form is clicked and the action is performed. After the action is done a message box pops up say that the action is done. Then if you go to a different sheet the userform doesn't unload. I can go back to the sheet that is supposed to have the form and use the form just like normal. It just doesn't unload after that one button has been clicked. Anyone have any ideas? -- JNW |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with worksheet_deactivate code
Do you toggle your events off without reseting them
Application.enableevents = false -- HTH... Jim Thomlinson "JNW" wrote: I've got a userform that opens when a sheet is active and is supposed to close when the same sheet is deactivated. This has worked fine in the past and I was wonder what if anything can be done. what happens now? It opens and closes normally until a button on the form is clicked and the action is performed. After the action is done a message box pops up say that the action is done. Then if you go to a different sheet the userform doesn't unload. I can go back to the sheet that is supposed to have the form and use the form just like normal. It just doesn't unload after that one button has been clicked. Anyone have any ideas? -- JNW |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with worksheet_deactivate code
Thank you Jim! That didn't even cross my mind.
-- JNW "Jim Thomlinson" wrote: Do you toggle your events off without reseting them Application.enableevents = false -- HTH... Jim Thomlinson "JNW" wrote: I've got a userform that opens when a sheet is active and is supposed to close when the same sheet is deactivated. This has worked fine in the past and I was wonder what if anything can be done. what happens now? It opens and closes normally until a button on the form is clicked and the action is performed. After the action is done a message box pops up say that the action is done. Then if you go to a different sheet the userform doesn't unload. I can go back to the sheet that is supposed to have the form and use the form just like normal. It just doesn't unload after that one button has been clicked. Anyone have any ideas? -- JNW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reasons why Worksheet_Deactivate fails? | Excel Programming | |||
Worksheet_deactivate fails - any ideas? | Excel Programming | |||
Worksheet_Deactivate() problem with deleting data | Excel Programming | |||
Worksheet_Deactivate() problem with deleting data | Excel Programming | |||
Capturing the selected tab in a worksheet_deactivate macro | Excel Programming |