Hello,
I have a shared workbook that is used by two groups of users. One group has modify rights and are the users that enter information. To avoid conflicting input (to minimize the odds that two users enter data into the same field at the same time) I would like the workbook to autosave at a given time interval - let's say every 5 minutes.
The second group of users have read only access to the workbook. I would need to have these users not autosave or they will get an error (I have disabled save-as).
Could someone help me out with some code that I could use to accomplish this?
Even better would be if there was an update command that would show all users all changes made without having to use the save command. This would allow the read-only users to see changes made by the users with modify rights more easily. I have searched around and have not found any options for this.
Any help would be greatly appreciated!
I have a shared workbook that is used by two groups of users. One group has modify rights and are the users that enter information. To avoid conflicting input (to minimize the odds that two users enter data into the same field at the same time) I would like the workbook to autosave at a given time interval - let's say every 5 minutes.
The second group of users have read only access to the workbook. I would need to have these users not autosave or they will get an error (I have disabled save-as).
Could someone help me out with some code that I could use to accomplish this?
Even better would be if there was an update command that would show all users all changes made without having to use the save command. This would allow the read-only users to see changes made by the users with modify rights more easily. I have searched around and have not found any options for this.
Any help would be greatly appreciated!
