| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initiating a macro from a control button
I have a large spreadsheet that has two possible ways of viewing by
hiding or unhiding columns. I can write a macro to hide or unhide the columns. What I am interested in is there a way to control macros for each view with a control button. Any advice would be very much appreciated. TerryM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Initiating a macro from a control button
Yes, it is not hard. You could have it such that the button has a state, if
pressed you get one view, if pressed again you get another. Or you could have click for one view and shift-click for another. What do you want? -- HTH RP "TerryM" wrote in message om... I have a large spreadsheet that has two possible ways of viewing by hiding or unhiding columns. I can write a macro to hide or unhide the columns. What I am interested in is there a way to control macros for each view with a control button. Any advice would be very much appreciated. TerryM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Initiating a Macro | Excel Worksheet Functions | |||
| Control button / macro | Excel Discussion (Misc queries) | |||
| Macro: automatically initiating upon cell click | Excel Discussion (Misc queries) | |||
| initiating a macro | Excel Worksheet Functions | |||
| assign a macro to a control button | Excel Discussion (Misc queries) | |||
Linear Mode
