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???
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???
Put this in ThisWorkbook module.
[VBA]
Private Sub Workbook_Open()
Application.Dialogs(xlDialogSaveAs).Show
End Sub
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
works like a charm!
thank you