How to create an automatic backup copy of worksheets. Create a backup copy of Excel worksheet when open. Delete backup copy when file closes.
For more help visit my website [ Ссылка ] or email me at easyexcelanswers@gmail.com.

Contact me regarding customizing this template for your needs.

Click for online Excel Consulting [ Ссылка ]

I am able to provide online help on your computer at a reasonable rate.

[ Ссылка ]

Check out my next one-hour Excel Webinar
[ Ссылка ]

I use a Blue condensor Microphone to record my videos, here is the link
[ Ссылка ]

Check out Crowdcast for creating your webinars
[ Ссылка ]

If you need to buy Office 2019 follow
[ Ссылка ]

I use Tube Buddy to help promote my videos
Check them out
[ Ссылка ]

Follow me on Facebook
[ Ссылка ]

TWEET THIS VIDEO

Follow me on twitter
easyexcelanswers

IG @barbhendersonconsulting

You can help and generate a translation to you own language
[ Ссылка ]

*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

code

Private Sub Workbook_Open()
Dim backup As Worksheet

Sheets("Sheet1").Copy after:=Sheets(Sheets.Count)
ActiveSheet.Name = "backup"

Sheets("sheet1").Activate

End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.DisplayAlerts = False
Sheets("backup").Delete
Application.DisplayAlerts = True

End Sub

свернуть