why macro slow first time
 

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

why macro slow first time
 

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.

"BillShut" wrote in message
om...
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