Command buttons or Menu

[Miya]

Hello, what do you think is best method when running macros, Buttons or menu? I do have buttons currently in various sheet, so the i have to keep going to those sheets to run.

 

[JP2112]

The method that works for you is the best method.

Personally, I use toolbar buttons for access to frequently used macros. That way, you can switch sheets and the buttons are still there; unlike worksheet-based command buttons, which only appear on specific sheets. And then there's personal.xls, if you keep your macros in there and use keyboard shortcuts, they'll always be available.

HTH,
JP

Hello, what do you think is best method when running macros, Buttons or menu? I do have buttons currently in various sheet, so the i have to keep going to those sheets to run.