Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Backup macro running twice
I have a user form that pops up to ask the user if they want to back u
their file after seven days. Everything works great except the for pops up twice no matter if they chose yes, no, or cancel. here is the "yes" code. Private Sub CommandButton1_Click() Unload Me Application.DisplayAlerts = False ActiveWorkbook.Save ActiveWorkbook.SaveAs ("s:\shared machining\backup\S-Bay Finis Paint.xls") Application.DisplayAlerts = True ActiveWorkbook.Close End Sub thanks for the help --Jeffer -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Backup macro running twice
Hi jsollman,
You can try: ActiveWorkbook.SaveCopyAs ("s:\shared machining\backup\S-Bay FinishPaint.xls") MP "jsollman " a écrit dans le message de ... I have a user form that pops up to ask the user if they want to back up their file after seven days. Everything works great except the form pops up twice no matter if they chose yes, no, or cancel. here is the "yes" code. Private Sub CommandButton1_Click() Unload Me Application.DisplayAlerts = False ActiveWorkbook.Save ActiveWorkbook.SaveAs ("s:\shared machining\backup\S-Bay Finish Paint.xls") Application.DisplayAlerts = True ActiveWorkbook.Close End Sub thanks for the help --Jeffery --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Macro to backup? | Excel Programming | |||
running a macro ina workbook that doesnt have that macro | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |