Sure,
Use the Before Save event like I told you back on the 12th.

Of course any macro based solution is easily defeated if the user disables
macros, including your macro.

My recommendation of making the workbook readonly might be the best approach
although that can be changed as well.

--
Regards,
Tom Ogilvy

"willroy" wrote in message
...
Patrick

Its taken me ages to find out that one little code!! Thanks for your
help.

You don't happen to know of a code where it will actually prevent
someone from saving though do you?

Sp for example, if somebody simply clicks the save icon (not save as)
an error message will appear saying for example "you are not able to
save".

Any ideas?

Cheers
Will


---
Message posted from http://www.ExcelForum.com/