Hello!

Quick question for a problem that should (at least I hope so) not be tricky for the real gurus here (tried searching but came up with a bit different solutions to which I am seeking).

I have a spreadsheet that has some 8 macros. I usually run those 8 macros separately. What I would like to do is create 8 checkboxes for each macro and then be able to run all the selected macros (1 to 8 at the same time).

For Example if I have Macro1, Macro3 and Macro7 checked in the checkbox, the new Macro would run those 3 macros. You get the idea. Any tips on how to create this Macro? Recording doesn't even record checkbox checkings..

Also, should I use activex or form checkboxes?


Sorry if this is a starter question, but I have only recently started doing things with VBA.

Many thanks in advance!