I want to prevent the user from saving a file name as a certain name.
That is, I am distrubtuting the excel file under a certain name and
want them to return it to me with a different name.

Say I distribute it as "Workbook1" and I want it returned as somethin
other than workbook 1.

I know I have to put a routine in the workbook module. And I a
assuming that it must be BeforeSave Event. But thats the extent of m
knowledge. How do I do this? I would assume it has to work in both th
Save and Save As mode too.

Thanks

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=26414