Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

assign a back up macro to save control

Status
Not open for further replies.

beginner999

Programmer
Mar 5, 2008
30
US
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.
 
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?
 
how and when to run this macro
Call it in the Workbook_Open event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top