assign a back up macro to save control

[beginner999]

How do I assign a macro to save control button on tool bar.
What iam trying to do is backup a file when the user save it.

 

[AnotherHiggins]

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.

 

[beginner999]

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?

 

[PHV]

how and when to run this macro
Call it in the Workbook_Open event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886