Open .XLAM as read only when custom toolbar button is pressed

[DreadfulDavid]

I have an .XLAM file with various macros and UDFs which a dozen or so people use.

I keep a master copy and have the users' copy in a standard location. Each user has customised ribbons with buttons which call the various macros. When a user first opens Excel, the .XLAM file is not opened but does open the first time they click on one of the buttons.

Is there a way to make this opening read only? I want to be able to update the file occasionally without contacting all the users and asking them to close Excel (and hence the .XLAM).

I could code to close the .XLAM file at the end of each macro but then the UDFs would not be available and I don't really want to separate them.

I don't want to change the ThisWorkbook ReadOnlyRecommended to TRUE as this pops up an unwanted dialog box.

I suppose I could make the file readonly each time I update it but this feels a little unelegant (and I'd forget )

Ta muchly

David

 

[RoryA]

I suppose I could make the file readonly each time I update it but this feels a little unelegant (and I'd forget )

That is the way to do it, inelegant or otherwise.

 

[DreadfulDavid]

Thanks, I had feared this.

How dreary - I guess I'll have to live with the diselegance

David