VBA to undo everything since last save

Will give a brief overview:
- Moving to SharePoint
- must use excel app (not online version) due to file macros / existing VBA
- people need to update the file so read only not an option
- people are having issues with understanding that they need to look if they are the only one in the file or not and those first in are getting frustrated when others pop in and make changes and cause issues and overwrites

Solution:
- Have a process where when a person logs in, it uses environment username and if username of person opening file... code below....

Please Login or Register  to view this content.

Problem is that for some reason, depends on how fast the connection of the person but we are seeing some people open the file and when others open the file, sometimes the first users name is showing (causing the 2nd to go read only) and sometimes the usernames are not showing in the file for the second person.
So I wanted to add a "save" after the if empty.....

Problem is that at the before close, the below is posted to give them the option to save or not and if they don't want to save, the clearing of the username is not "saved".

Please Login or Register  to view this content.

So what we need to do is that if the person says they don't want to save, we need to undo all they did PLUS clear the username in A1 and re-save then close.

This way, if people are opening after the first person, the first persons name is "saved" causing them to go read only or close and no chance of them opening files that have not updated on the server due to a lag.

Hope this makes sense as this is the last hurdle to complete what has been a long process. At least I hope this is the last one!

Appreciate any and all help/guidance.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

The post has been modified as directed - very much would appreciate assistance.

It is time for you to read our forum rules that you agreed to when you joined. Second offense in the day.


crossposted: https://www.mrexcel.com/board/thread...a-vba.1188057/


Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. I have provided that link for you today.)