Macro for closing and reopening a workbook read-only

[Remster]

I have a pair of macros that together close and reopen a workbook when the user clicks on a button labelled 'Refresh'. The reason for the macros is that any one of multiple users may have the workbook open for editing while the others have it open read-only, and those who have it open read-only will want to refresh it periodically to make sure they're viewing the most up-to-date version.

Now, here's the hitch. If I have the workbook open read-only and refresh it while no-one else has it open for editing, it doesn't reopen read-only (it reopens for editing). But I don't want it to reopen for editing (I want it to reopen read-only). Is there anything I can add to the macros to make the workbook reopen read-only, or is there a different pair of macros I can use? Here's what I have at the moment:

Macro 1
Sub CloseMe()
'
Application.OnTime Now, "OpenMe"
ThisWorkbook.Close SaveChanges:=False
'
End Sub

Macro 2
Sub OpenMe()
'
End Sub

 

[Airfix9]

So long as it is only open once as read-write, you should have no problem. I tested my solution here with a colleague and it worked like a dream.

One thing though, assuming that the read-only users would not read-write, you should really only give them that option on opening the file, otherwise they could be in it read-write when another user needs to update it.

 

[Remster]

So long as it is only open once as read-write, you should have no problem. I tested my solution here with a colleague and it worked like a dream.

It isn't saved as a shared workbook, so that shouldn't be a problem (I'm assuming that by 'only open once as read-write' you mean 'open as read-write by only one user at a time').<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>

One thing though, assuming that the read-only users would not read-write, you should really only give them that option on opening the file, otherwise they could be in it read-write when another user needs to update it.

The Web page from which users will be opening the file has read-only as its default option – they have to make a bit more effort to open it for editing – so that shouldn't be a problem either.<o></o>
<o></o>
Many thanks for your help.