A
Al
I had a macro that worked great until this morning. This
morning Office 2003 (Windows 2000) was installed on my
machine. Previously I had Office 2000 (Windows 2000) with
the Excel 9.0 Object Library. No problems, life was good!
Now I get the following error: Can't exit design mode
because Control "ImgEdit1" can not be created.
Nothing has changed with the macro. The same file was
opened yesterday and today with painfully different
results. Is there something in the 11.0 library that has
changed from the 9.0 library?
Here is the code when the workbook opens:
Private Sub Workbook_Open()
Pic = "L:\North America\6699\wrappedcarnew1.tif"
Worksheets(1).ImgEdit1.Image = Pic
Worksheets(1).ImgEdit1.FitTo 0
Worksheets(1).ImgEdit1.Display
Range("L1").Select
*** Rest of code
End Sub
Any help or suggestions on how to correct or code the
macro so I don't get this error would be greatly
appreciated. Thanks for the help.....Al
morning Office 2003 (Windows 2000) was installed on my
machine. Previously I had Office 2000 (Windows 2000) with
the Excel 9.0 Object Library. No problems, life was good!
Now I get the following error: Can't exit design mode
because Control "ImgEdit1" can not be created.
Nothing has changed with the macro. The same file was
opened yesterday and today with painfully different
results. Is there something in the 11.0 library that has
changed from the 9.0 library?
Here is the code when the workbook opens:
Private Sub Workbook_Open()
Pic = "L:\North America\6699\wrappedcarnew1.tif"
Worksheets(1).ImgEdit1.Image = Pic
Worksheets(1).ImgEdit1.FitTo 0
Worksheets(1).ImgEdit1.Display
Range("L1").Select
*** Rest of code
End Sub
Any help or suggestions on how to correct or code the
macro so I don't get this error would be greatly
appreciated. Thanks for the help.....Al