Message 1 of 3
default.ivb - What is the best location for the Default VBA Project?

Not applicable
12-07-2009
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Are there best practices for this?
There are a few custom macros that all the users here make use of.
Before, the Default VBA Project pointed to the default.ivb in the local hard drive of each users machine. If there was an addition or update to an existing module, I went through each user's machine and imported the new macro.
After doing this once, I decided to place the project.ivb in the network. I then changed each user's Default VBA Project location to point to the project.ivb in the network. This seemed to be the perfect solution - if I updated or added modules, all the users would have access to it automatically.
A few days later, I realized that when open Visual Basic editor, the project.ivb is set to read-only and if I edit or add modules, it will not be saved.
How can I make the Default VBA Project work on a multi-user environment?
There are a few custom macros that all the users here make use of.
Before, the Default VBA Project pointed to the default.ivb in the local hard drive of each users machine. If there was an addition or update to an existing module, I went through each user's machine and imported the new macro.
After doing this once, I decided to place the project.ivb in the network. I then changed each user's Default VBA Project location to point to the project.ivb in the network. This seemed to be the perfect solution - if I updated or added modules, all the users would have access to it automatically.
A few days later, I realized that when open Visual Basic editor, the project.ivb is set to read-only and if I edit or add modules, it will not be saved.
How can I make the Default VBA Project work on a multi-user environment?