Can you copy a worksheet without renumbering autoshapes?

marcs

Active Member
Joined
May 3, 2005
Messages
420
Can you copy a worksheet without renumbering autoshapes?
I've got a template with several autoshapes on it and when it gets copied the new shapes get new numbers. This makes it difficult to work with. Is there any code which will prevent this renumbering? All help much appreciated.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,118,736
Messages
5,573,926
Members
412,555
Latest member
mark84
Top