force user to Save As if document is in a specific file directory on opening

[ebrandt]

Is there vba code that can check the current file directory and force a user to save as to a new directory and file name on opening?

I have not wanted to set up my file as a template, but I don't want users making changes to the master file and saving it.

 

[James006]

Hello,

Believe you could use the Private Sub Workbook_BeforeSave() event to ensure things are done the way you want ...

 

[Jaafar Tribak]

Is there vba code that can check the current file directory and force a user to save as to a new directory and file name on opening?

I have not wanted to set up my file as a template, but I don't want users making changes to the master file and saving it.

Have you considered making the file Read Only with a password that only you knows ?

 

[ebrandt]

Sometimes the simplest solutions are the best. Thank You Jaafar!