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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Neil Holden" wrote:

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.