Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error 1004 generated in Excel (Office 2003)
I have code originally generated in excel (office 97). The code is a
simple maco which runs when shape (which looks like a Button) held on a worksheet is clicked. One of the requirements is that the button should be deleted from the worksheet to stop the code being accidentally re-run. The following code works in Office '97 but generates a run time error in 2003 If IsAnyShape(wsSrc) = 1 Then wsSrc.Shapes("ImpPhotoBut").Delete End If Where IsAnyShape tests for the existence of a shape wsSrc is a worksheet variable ImpPhotoBut is the name given to the shape Incidentally 'wsSrc.Shapes(1).Delete' delivers the identical error. Any thoughts on why the error occurs in the later software platform and /or a workaround for this code. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error 1004 generated in Excel (Office 2003)
The.Delete works for me in XL2K.
What is the IsAnyShape function ? NickHK groups.com... I have code originally generated in excel (office 97). The code is a simple maco which runs when shape (which looks like a Button) held on a worksheet is clicked. One of the requirements is that the button should be deleted from the worksheet to stop the code being accidentally re-run. The following code works in Office '97 but generates a run time error in 2003 If IsAnyShape(wsSrc) = 1 Then wsSrc.Shapes("ImpPhotoBut").Delete End If Where IsAnyShape tests for the existence of a shape wsSrc is a worksheet variable ImpPhotoBut is the name given to the shape Incidentally 'wsSrc.Shapes(1).Delete' delivers the identical error. Any thoughts on why the error occurs in the later software platform and /or a workaround for this code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004 When running in 2003 | Excel Discussion (Misc queries) | |||
Run-time error '1004' VBA Excel 2003 | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
EXCEL VBA - Run-time Error 1004 | Excel Programming | |||
EXCEL VBA - Run-time Error 1004 | Excel Programming |