Force read only / acquire write permission

Hello Excelforum!

I have a collection of macros that I share with other computers on my network. The macros is shared on a network drive accessible to both computers stored at Z:\Excel Macros\smpitaReports.xlam as an Add-in file. I am constantly updating and tweaking the macros but whoever is the first person to open their Excel gets write permission and the rest of us get read permission. I need to figure out a way to control this without changing network/filesystem permissions.

I figure the best way to do this is to make everyone open the file as read only by default and then when I need to make updates to it, run a macro to acquire write access. Can this be done in VBA? I have access to each terminal Excel so I can put in a startup macro to check for write access and then drop to read only if write access is found. I started to try to piece it together from searching the internet but I'm hitting a brickwall at the start. This is as far as I've gotten which is a failed attempt at a basic check for read only access that gives me an "Object Required" error.

Please Login or Register  to view this content.

Is there an easier way to do this? Ideas are welcome.

Thank you for your time!

Hello TMS!

Thank you for your attention to my thread! I get the error "This workbook is currently referenced by another workbook and cannot be closed" on the line

Please Login or Register  to view this content.

Thanks TMS!

With more research, I have decided to change my deployment method. I mostly followed the guidelines on another site, keeping the development copy on my computer and pushing a read only copy to the network share for others to use. I used the following code template:

Please Login or Register  to view this content.

Closing thread and marking as solved.