why macro slow first time

  • Thread starter Thread starter BillShut
  • Start date Start date
B

BillShut

I have a macro on a toolbar button that gives the option of editing a
macro, using username or another name or just comment. Thanks to
everyone for all the help to get it working well (input box, msg box
etc.) but the first time I run it it is slow, the second time it just
flashes up the comment box.

Wondering why.

Thanks
 
When a macro is run the first time, it has to be compiled. Unless you make
changes, the macro need not be compiled again. That's why the macro runs
slower the first time.
 
Back
Top