How do I write a menu to run my macros?

[rookie37]

I want to hide and unhide 12 tabs

Instead of having 12 buttons, I'd like one button pointing to 12 macros

I don't want a fancy menu but I would like to make 2 groups
(perhaps all 12 macros on one page but in two columns with a North and South label on each column)

Group n
Group s

Below is only two macros instead of twelve but it shows the n and s group

Please Login or Register  to view this content.

Many thanks

[royUK]

You can assign the macros to buttons or images & arrange them how you want

http://excel-it.com/add_button.htm

[rookie37]

You can assign the macros to buttons or images & arrange them how you want

http://excel-it.com/add_button.htm

I only know how to write 12 buttons on my spreadsheet
I'm trying to write only one