This issue is not about writing code, more about what/how to place the code
once it's running properly. I do a lot of work on spreadsheets that are
already in use. I debug, or add features, or update, etc. So I copy a
spreadsheet that is out on the LAN for multiple user access, and then make
changes. If they're amall changes to a single macro, I just copy and paste
that particular macro into the "working" workbook. But what about when I
make extensive changes? Now I have the "working" spreadsheet on the LAN and
one with extensive changes to it on my machine. What is the safest way to
get all the new macros into the "working" sheet? Export/Import? Copy and
Paste? Copy the data sheets into the one with the updated macros? Seems to
me there could ba a "best practice". Or not.
Thanks in advance.