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 |
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 |