SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 731
- Office Version
- 365
- Platform
- Windows
I have a file that about 15 people need to access. Right now, we all copy records assigned to us each day and put them in our own individual files. I want to use a shared file that we can all access simultaneously but I'm not sure of the best options. We all have access to a shared network drive where we keep our files now but we also have Microsoft Teams and One Drive.
Where should I save the shared file so the each of us can run macros contained in the file? Right now, each person runs the same macros in their own individual files to display things for just the records that show their userid in the record. So in the shared file, if I run a macro that displays just my records and adds a column to show record age but then another person does the same thing what happens if they run the same macro? Can You even have macros in a file shared in each location? Are there other issues I should consider?
Where should I save the shared file so the each of us can run macros contained in the file? Right now, each person runs the same macros in their own individual files to display things for just the records that show their userid in the record. So in the shared file, if I run a macro that displays just my records and adds a column to show record age but then another person does the same thing what happens if they run the same macro? Can You even have macros in a file shared in each location? Are there other issues I should consider?