SAVE AS

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

 

[Jacob Skaria]

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

 

[Neil Holden]

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

 

[Bob Phillips]

Then check it

Private Sub Workbook_Open()
With Me

If .Name = "Master.xls" Then

.SaveAs Application.GetSaveAsFilename
End If
End With
End Sub

 

[Jacob Skaria]

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

 

[Neil Holden]

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.

 

[Jacob Skaria]

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

 

[Neil Holden]

Thanks Jacob much appreciated.

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