PDA

View Full Version : Solved: Automatically Save As when file opens



agnesz
05-29-2009, 01:10 PM
Is there any way I can have vba in a file which automatically, once a file is opened, it prompts the user to Save As???

mdmackillop
05-29-2009, 01:55 PM
Put this in ThisWorkbook module.

Private Sub Workbook_Open()
Application.Dialogs(xlDialogSaveAs).Show
End Sub

agnesz
05-30-2009, 08:56 AM
works like a charm!
thank you