Can I create a excel "work" macro .bas file to be accessed by other users on a work network

[EdieS]

The work macro .bas file would be saved like the personal macro .bas file and hidden on the network.
Could the macros in the work macro .bas file accessed by other workbooks, the same macros would be used by other workbooks to mainly select cells, filtering and sorting nothing real fancy?
Or is there a better solution?

 

[mrshl9898]

Only real solution is to load it into all their Personal Workbooks.

That being said, you could just code that i'd imagine and have them run an install macro.

 

[EdieS]

Thank you. I had a co-worker open the workbook and she could run the macros. I'm thinking that since I'm not on a personal drive, we have Teams and SharePoint that the "hidden" folder it might be saving the macros to .bas folder that is not user identified because of the network. We're going to test this theory further. Appreciate your input.