DDRA Steampunk
New Member
- Joined
- Feb 10, 2017
- Messages
- 23
Is there some kind of option or code to clear/replace VBA code? I have a workbook with about a hundred pages and I have just a snippet of code that needs to go on most but not all of them to make a toggle button work by calling the sub from the right module. I can't just find/replace because I am replacing a huge block of code with a tiny one and Excel doesn't seem to like that. Opening the code windows and ctrl+v ctrl+v crtl+v... argh! Just kill me now. I read a thread earlier about how to automatically create a macro button instead of the Active X button I used. If all else fails that's my backup plan. Suggestions much appreciated!