Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error deleting worksheet (Excel 2003)
I'm getting the following error: "Run time error -2147221080: Automation error" running an excel macro in 2003. I think the problem is when I try to delete a worksheet with a command button on it. I think somehow the button creates a reference to the worksheet and this causes a problem when I delete the worksheet. To duplicate this error add a button to the first worksheet and step thru the following code using F8: sub test Worksheets(1).Delete end sub After deleting the worksheet I get the following message: "Can't enter break mode at this time" I think this is leading to the Automation error. Any workarounds? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Worksheet in excel = 2003 / 2007 | Excel Worksheet Functions | |||
Excel 2003 converted to 2007 copying worksheet error | Excel Discussion (Misc queries) | |||
-2147417848 Error Code - Deleting a Worksheet using VBA | Excel Programming | |||
Deleting Worksheet Error | Excel Programming | |||
error runtime 9: deleting a worksheet | Excel Programming |