Not sure I understand your request. Do you mean that you want to back up a copy of what it was like Before they changed it? If so, the only way I can think of is to force the user to Save As instead of Save.
Or do you want to save another copy of their changes to another folder somewhere?
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
Sry I was not clear in my last post. What Iam trying to do is save a back up before we make changes to excels file. How can I do that? Anything that saves backup automatically would help. I already have a macro for back up. Just don no how and when to run this macro?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.