form buttons

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have been working with form buttons running some macros........ as I have
been experimenting alot, each time I create a button the number on the
button advances... I am up to about 78 now!
Is there a way to reset these numbers to start at one again?... same
question for macros that I have recorded.
thanks
 
Just my opinion--don't worry about the sequence numbering.

But if you don't like the name, change it to something meaningful.

Rightclick on the button and type your new name in the namebox (to the left of
the formula bar).

It might make it easier when you're reviewing the workbook in a few months.

And the same thing for the macro names. Don't leave them macro93. Change it to
something meaningful.

(But don't use the same name as the module containing the macro or even the same
name as a workbook name.)

(I thought that sometimes closing the workbook and reopening would reset those
sequence numbers, but I didn't test it.)
 
Back
Top