I have noticed many subtle differences in working with code from 2000 and
from 2003, usually just more or less options per function. Your code here
appears correct, and it worked when I tried it. Are you sure your shapes are
named the way the code assumes they are?

Pflugs

"darthrader" wrote:


I have worsheets that used to work with Excel 2000 and now cause errors
since I upgraded to Excel 2003.

I get the following error when I run the macro;

Run-time error '-2147467259 (80004005)':
Method 'Select' of object 'Shape' Failed

From the following line of code;
ActiveSheet.Shapes ("Rectangle 7") .Select

Any suggestions?


--
darthrader
------------------------------------------------------------------------
darthrader's Profile: http://www.excelforum.com/member.php...o&userid=36359
View this thread: http://www.excelforum.com/showthread...hreadid=561465