Prevent Particular File Name during Save
 

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

Prevent Particular File Name during Save
 

hi.
have you given thought as to how much disk space you are
going to be useing.
might be better just to re-name it.

-----Original Message-----

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 I
want them to return it to me with a different name.

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

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

Thanks.


--
ExcelMonkey
----------------------------------------------------------
--------------
ExcelMonkey's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=5221
View this thread:
http://www.excelforum.com/showthread...hreadid=264147

.