I am creating a worksheet that has over 1,000 toggle switches in it. I created one main macro that contains a specific macro for every single switch. Having such a long macro, one that covers thousands of switches, has caused the spreasheet to take literally 30 minutes to open. I need to find a way to assign one macro or even script to run regardless of what toggle switch I'm on. Is there any way of doing this? I've done it in other programs but cannot figure out how in excel.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
macros assigned to toggle switches
- Thread starter vincej
- Start date
Can you post an example of the code? If it's approximately the same, then you could probably use a class module with the keyword WithEvents to create a "typical" button with your special code in the Click event.
Once I see some code, I think I'll be able to explain better (with code examples).
Scott
Once I see some code, I think I'll be able to explain better (with code examples).
Scott
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
- Locked
- Question