SAVE AS

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

Morning all excel gurus. I have a master excel document and when a user
opens it, i need it to automatically prompt for save as so the master is
never touched.

Please help.
 
From VBE left treeview double click 'This WorkBook' and paste the below code
to the right code pane.

Private Sub Workbook_Open()
Me.SaveAs Application.GetSaveAsFilename
End Sub

If this post helps click Yes
 
Hi thanks for that, the trouble i have now is if the user opens the excel
file that they have saved its still asking to save as.. I only want it to
show that on the master document, also is they anyway i can stop it from
defaulting the save as name?

Thanks Jacob.

Neil
 
Then check it

Private Sub Workbook_Open()
With Me

If .Name = "Master.xls" Then

.SaveAs Application.GetSaveAsFilename
End If
End With
End Sub
 
You can...Edit the workbook master file name...in the below code...

Private Sub Workbook_Open()
If Me.Name <> "master.xls" Then _
Me.SaveAs Application.GetSaveAsFilename("")
End Sub

If this post helps click Yes
 
Hello again, if the excel sheet = master then prompt for save as else ignore?

Currently that ignores master and asks to save as all other excel sheets.

Thanks.
 
Yes...I meant so..

Private Sub Workbook_Open()
If Me.Name = "master.xls" Then _
Me.SaveAs Application.GetSaveAsFilename("")
End Sub

If this post helps click Yes
 
Thanks Jacob much appreciated.

Jacob Skaria said:
Yes...I meant so..

Private Sub Workbook_Open()
If Me.Name = "master.xls" Then _
Me.SaveAs Application.GetSaveAsFilename("")
End Sub

If this post helps click Yes
Click to expand...
 
Back
Top