Prevent Particular File Name during Save

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check File Name before Save Event 1
Suggest a file name OnSave 2
Opening a list of Excel files and run a macro in each 17
Problems with Workbook Before Save Event 7
Save As and new workbook new name used in existing code 8
User defined menu stops working when workbook saved with a newname??? 4
Preventing Range Name changes 3
Copy data from workbook 2 to workbook 3 mystery! 2

Back
Top