Hopefully this will come across right ? I have a macro using the following to bring a shape to the front:
When I make a copy of that sheet the shape becomes a different number for ex. "Rectangle 447" becomes "Rectangle 445" and the macro will not work properly on that copied sheet. Is there any fix for this?
Please Login or Register to view this content.
Thanks in advance,
Beatnik
Last edited by beatnik; 10-17-2008 at 06:55 AM.
Hello Beatnik,
You can prevent this problem by changing the Shape's default name.
Sincerely,Please Login or Register to view this content.
Leith Ross
I'm guessing this would be done when the workbook is opened ?
Hello beatnik,
Anytime before the shape is copied to the other workbook.
Sincerely,
Leith Ross
That definitely helped ! A bit of tinkering and it's working fine, added this to happen when the workbook is opened. Now the macro works on all copied sheets.
Thanks, I was surely lost.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks