ElCaito
12-13-2005, 10:16 PM
Hi.
I am new to the forums.
How is it possible to delete the worksheet that has the actual code running from it?
I have three worksheets, where one is "MAIN" and it has the ActiveX command button to fire up the code I've got. When the program is about to complete, it attempts to delete this worksheet along with another.
It deletes another worksheet, no problem, but when I try to delete the "MAIN" worksheet, which has the code, I get this an "Automation" error, saying Run Time error "-2147221080".
Is there a way to force a command button to run code from another location?
Thanks in advance.
I am new to the forums.
How is it possible to delete the worksheet that has the actual code running from it?
I have three worksheets, where one is "MAIN" and it has the ActiveX command button to fire up the code I've got. When the program is about to complete, it attempts to delete this worksheet along with another.
It deletes another worksheet, no problem, but when I try to delete the "MAIN" worksheet, which has the code, I get this an "Automation" error, saying Run Time error "-2147221080".
Is there a way to force a command button to run code from another location?
Thanks in advance.