Hi Peter,
Why not save your template as an actual Template, saveas Save as Type
scroll down to template.
When you distribute to your users ensure it's saved in their template's
folder, so all they have to do is File New and select your template.
s = Application.TemplatesPath
It's not straightforward, if indeed possible, to ensure user only saves to a
designated folder. When user clicks Saveas the Beforesave event fires (and
returns SaveAsUI = True), but thereafter user can change name & folder.
Look at ChDir
Regards,
Peter T
"peter.thompson"
<peter.thompson.21mcty_1137232801.5666@excelforu m-nospam.com wrote in
message news:peter.thompson.21mcty_1137232801.5666@excelfo rum-nospam.com...
I want to prevent a user from ever overwriting a certain file:
"C:\Business Cases\Master Template.xls" i.e. I want to preserve the
integrity of the template.
I also want the user to always save files in the "C:\Business Cases"
folder, which is automatically created the first time the workbook is
opened
Would appreciate any help on the best way of going about this - it's
been a very long day!
Cheers
Peter (...slogging it through VBA)
--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile:
http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=501322