One work around is to name them with consecutive numbers. But it seems like
there is a way to reset the index numbers also. I am sure there is on a
form, and I would think you could do it on a sheet also.


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system so
subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.

--

Gary Keramidas
Excel 2003