I have a workbook with many userforms and macros that I built to automate many accounting journal entries and functions. It works great. However, this workbook is being utilized by my department while I am still working to evolve and grow the functionality. Currently, there is a master copy saved on the server that people can copy and paste to use on their local machines to use. This isn't a great solution because this means people need to copy a new version of the workbook every time an update or new feature is added.
What I am looking for is either a way for everyone to access and use the same workbook simultaneously. Or, a way to have all the vba reside in one place and have the individual copies all point to the same code.
If you are able to point me in the right direction please do so. It would be greatly appreciated!
Thanks
What I am looking for is either a way for everyone to access and use the same workbook simultaneously. Or, a way to have all the vba reside in one place and have the individual copies all point to the same code.
If you are able to point me in the right direction please do so. It would be greatly appreciated!
Thanks