Saving Issues

[asjmoron]

Hi all,

Im not sure if this possible but any ideas would be amazing!

I have a sheet that is used by a colleague of mine and she keeps accidently saving it in random places which breaks all of the external refs. Is there a way to set the sheet to only be able to be saved in one location?

Im not holding my breath on this one...

Thanks!

 

[alansidman]

Record a macro that saves the file to the correct location. Then instruct your co-worker on how to save using the macro.

 

[asjmoron]

@alansidman

why did I not think of that!