| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Save As Macro
Thank you. The second macro did the trick.
"Dave Peterson" wrote: Option Explicit Sub Auto_Open() Msgbox "Remember to save as a new name. Well, if you want!" End Sub or Option Explicit Sub Auto_Open() Application.Dialogs(xlDialogSaveAs).Show End Sub To just show the File|SaveAs Dialog wrvadmin wrote: I need help in creating a macro that will prompt the user who opens the workbook to automatically save the workbook with a new file name. I have a workbook that is revised on a daily basis and I want to maintain the previous day's file. I am generally the one who opens the workbook, but there will be days when someone else opens it on their computer. It doesn't have to be a mandatory save, but I want the prompt there as a reminder to save with a new filename. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Save As | Excel Discussion (Misc queries) | |||
| Excel Automatic Calculation Options will not Save | Setting up and Configuration of Excel | |||
| Automatic Save and Exit | Excel Discussion (Misc queries) | |||
| Automatic save workbook | Excel Worksheet Functions | |||
| How do you turn off automatic "save a copy" in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
