Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Can anyone please help me. The scenario is ......... I have a workbook with two worksheets. The first worksheet contains the "Reporting Form (Range A1:I356) and is constant, it never moves with additions and deletions there are no cells added or deleted" and the second worksheet contains the "Data Input Form (currently the range is A1:CW356 and is constantly moving wider)". Both worksheets are working fine but each worksheet has around 20 macro buttons along the top which are needed as a "One Click" to Auto Filter the data required. What I would like to do is click one button on the worksheet and all these buttons then pop-up on a sized dialog box until the selection is made then close the dialog box. The reasons for doing this are that the all the buttons take up around 1/3rd of my screen vision Any help provided would be greatly appreciated and I thank you all in advance -- Peter W Soady |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Pause during Dialog Box data entry | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
opening different programs with excel macro buttons | Excel Worksheet Functions | |||
Macro to pause for user input in dialog box | Excel Discussion (Misc queries) | |||
how to use the search dialog via a macro? | Excel Worksheet Functions |