I am no expert but a simple solution is to create a custom toolbar with all
your macro assigned with the buttons on it.

"mcm" wrote in message
...
Hi all

I'm trying to build a floating control box with several buttons on MS
Excel. Originally, I was able to build macro buttons on the first
sheet of my workbook. Let's refer to the first sheet as 'main'. The
other sheets we can call sheet1, sheet2, etc. up to sheet20.

On the 'main' worksheet I created 20 buttons corresponding to the 20
sheets. So anyone who wants to view a sheet, they will click on the
command button for that sheet to view it. However, what I really
wanted was a floating control box with all 20 command buttons present
in it. This way there will always be one active sheet in the workbook
and the rest will be hidden. Right now, the 'main' sheet is always
active (because the command buttons are on it) and the sheet following
it would be the chosen sheet/s to be viewed.

Help!
Thanks

PS: if there is better way to do it other than using command buttons,
your advise would be appreciated.