Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
One macro for many controls?
I really dislike the check boxes from the Control toolbar. The one on the
Forms toolbar is so much easier to implement. But there are times when I want them to move and size with cells (like when I hide unused rows). So I end up spending hours implementing dozens of identical check boxes. Right now I have 26 that all call identical macros. It appears that I can't have them all call the same macro, but that I must have 26 separate macros. Is it possible for them all to call just one? I am using Excel 97. One of my problems with using a check box from the Control toolbar is the focus stays on the control. This is not good. So the macro each calls runs: Application.ScreenUpdating = False Range(ActiveCell.Address).Select Am I missing something here? Is there a simpler way to do this? Don <donwiss at panix.com. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using gui controls | Excel Discussion (Misc queries) | |||
HTML Controls | Excel Discussion (Misc queries) | |||
Volatile Macro for Adding Controls When Opening Workbook | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
macro that copies controls | Excel Programming |