Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving "ThisWorkbook" code
I save all the code I write to reuse or use as a reference later. I
just save the module in a "bas" directory. Now I've written a couple of sets of code in "ThisWorkbook". If I try to save the new code under that file name, it will overwrite the old code. The easiest fix I can think of is to copy the "ThisWorkbook" code to a module, put in a remark that it needs to be in "ThisWorkbook" to run (event triggered) and save the module under some appropriate name. Is this how others do it? Is there a better way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programatically adding macro to Excel - "ThisWorkbook" | Excel Discussion (Misc queries) | |||
Can I disable a macro in "Thisworkbook" with true or false? | Excel Programming | |||
What type of code do you put in "ThisWorkBook"??? | Excel Programming | |||
How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ? | Excel Programming |