Skybluekid
Well-known Member
- Joined
- Apr 17, 2012
- Messages
- 1,231
- Office Version
- 365
- Platform
- Windows
Hi All,
I create a lot of files, approx. 300-400, using Excel and they are stored on Sharepoint(Teams interface). In the files, I have various bit of VBA in each file.
The issue I am having is when I update the VBA, I have to go into all the files and update that bit of VBA. Is there a way to store the VBA in a central file and have each of the file reference the central file for the VBA. This way, when I update the code, all files will be updated.
Thanks in Advance.
I create a lot of files, approx. 300-400, using Excel and they are stored on Sharepoint(Teams interface). In the files, I have various bit of VBA in each file.
The issue I am having is when I update the VBA, I have to go into all the files and update that bit of VBA. Is there a way to store the VBA in a central file and have each of the file reference the central file for the VBA. This way, when I update the code, all files will be updated.
Thanks in Advance.