Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello folks
I have a worksheet with a number of toggle buttons on it, which is menu for opening other workbooks. When the user double clicks a toggle button it opens a workbook. However, the idea is that if the user wants to open more than one workbook, then they can select the desired sheets via the togglebuttons and then click a command button to open all where the togglebuttons are true. How can I loop through the togglebuttons and if they are true call the double click event? I need the code to be faily adaptable as there will be new buttons added in the future. I'm using XL2000 Many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looping over a worksheet | Excel Programming | |||
'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
Adding buttons while looping through files Question | Excel Programming | |||
looping thru the worksheet | Excel Programming | |||
Looping Through Worksheet | Excel Programming |