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/

.