John has attended:
Excel Advanced course
Macro's in excel
I was wondering if anyone has any good practical applications for making macro buttons, as I am finding it hard to think of where I might use them
RE: Macro's in excel
Hi John
Macro buttons are created in a workbook to run specific macros. They are used as a short cut so that the user doesn't need to go into the menus to run a macro.
So if you have a macro that imports data into a worksheet, formats it and calculates sections of it, you could have a button or group of buttons on the worksheet that would run the relevant section everytime you clicked them
Hope this helps
Carlos