Keeping Macros/VBA with document
I had an interesting surprise when I got home and pulled up my network stored .docx document over the company VPN to find that all my VBA code was inaccessible! How can I bind all my VBA code for this project to this one particular document? When I complete my code and I assign to, say a button and then deliver it to a co-worker, how to I ensure every bit if intended code runs on the delivered document? As I mentioned above, this document is stored on our network an I need anyone on the network who pulls it up to be able to run the code intended for it?
|