Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent from save if... | Excel Discussion (Misc queries) | |||
Prevent save when content change? | Excel Programming | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Help! MsgBox and Prevent Save | Excel Programming | |||
prevent user from saving file to a folder but allow my code to save from behind. | Excel Programming |