Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating control box
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Charts: "Floating Maximum" | Charts and Charting in Excel | |||
Control Charts: "Floating Maximum" | Charts and Charting in Excel | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Excel spin box - no Control tab in Format Control dialong box | Excel Worksheet Functions | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) |