I suggest you make the file read-only using Windows Explorer, instead of
saving it with read-only recommended. In Windows Explorer, right-click on the
(closed) workbook. Select Properties put a check in the 'read-only' box
OK. Unless your users reverse this procedure in Windows Explorer before
opening the workbook, they won't be able to save over it from Excel. Making
the file read-only also inhibits accidental deletion by requiring
confirmation first.

If you want to try Workbook_BeforeSave event code, it only needs to contain
the statement Cancel=True.

Hope this helps,

Hutch

"Robert Crandal" wrote:

Ooops, let me re-phrase that:

I am still interested in knowing about any of these ideas
that are NON-foolproof!

8)


"Robert Crandal" wrote in message
...
I realize that no solution is foolproof.....

I am still interested in knowing about any of these ideas that are
foolproof. 8)

How can I intercept the menu "Save As" command?? Is the
solution related to the Workbook_BeforeSave() function???



.