Resetting EXCEL Object internal Counters

[tmktech]

Hey, it's TMKTECH again. I'm double-dipping today.

Question: Is there anyway to reset the internal object counters (sheets, shapes, textboxes, etc.) within EXCEL.

From a development standpoint, some of my modules have been are several years old and the object numbers are getting quite large.

Thanks again!

TMKTECH

 

[RobBroekhuis]

Why do you need to reset them? You probably assign meaningful names to these objects anyway when you create them, so the initial numbered name is just temporary.
Rob

 

[tmktech]

Rob, I think I had a braincramp. I used a drawsing object for a checkbox rather than a CONTROL (which can be named). I thought I had seen somewhere also that the system name had to be referenced by VBA code (hence my question), but I can't seem to find it now.

Thanks for you reply!

TMKTECH