Several choices
1) is set the file READ-ONLY attribute to True in Explorer
2) trap the before -save event - see the earlier reply
which gives an example
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi all,
I have a workbook that is to not be overwritten. It is
basically a
template to use for quoting. How do i avoid having the
workbook
overwritten. Do i save as a template?? I would like
possibly a prompt
message before the user closes the book to ensure it
isnt overwritten
IE: "Have you saved as a different name?"
How is this done??
Cheers all !!!!!!
---
Message posted from http://www.ExcelForum.com/
.