Floating control box
Hi
You could add a right click menu option to your workbook,
called 'Main'. Then add all the sheets 'sheet 1' 'sheet
2' etc below that, when the user click the sheet name it
takes them to the sheet.
You can easily hide the menu option when you switch to
another workbook
-----Original 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.
.
|