time-out close of workbook, without saving if open as 'read-only'

**DebLucas** · 07-01-2015, 03:29 AM

Hi,

I have a lot of workbooks that are shared between mulitiple users so I have added the option to open as read only if they are not going to be changing any data. I have also managed to set it up to automatically save and close after 10 minutes of inactivity. My issue now is that the read only version tries to save the document under a new file name at the end of 10 minutes, does anyone have any code that could help me to either not auto close a read-only workbook or to not save before closing?

Thank you

**mongoose36** · 07-02-2015, 11:06 PM

What I have done for workbooks that multiple users use and which I do not want to have read-only copies open is to write code in a workbook_open sub which checks if the workbook is read only and if so closes the file. You may not want the file closed, but you should be able to do a similar check in the code that saves and closes after 10 minutes. For example it only saves and closes a workbook that is not read only.

time-out close of workbook, without saving if open as 'read-only'

LinkBack

Thread Tools

Rate This Thread

Display

time-out close of workbook, without saving if open as 'read-only'

Re: time-out close of workbook, without saving if open as 'read-only'

Thread Information

Users Browsing this Thread

Similar Threads

Copy from first workbook, close open new workbook paste close

Open workbook in read only or read write for excel 2010 version

Open excel file read the data and close

Macro to close a workbook after x amount of time when its open read only

Save an open workbook, then open template workbook and close the saved workbook

Bookmarks

Bookmarks

Posting Permissions