A macro to stop a workbook from being saved if it has certain file name. e.g. 'Blank Doc

Hi all,


I have a blank data workbook which is used to create a new workbook once a date has been entered. Can I prevent anyone from saving the blank workbook with a macro?

English is a wonderful language - Ambiguities all over the place.

Do you mean:

• Using a macro to prevent saving any workbook if all the cells are blank.

or

• Prevent saving a workbook if it is blank and contains macros

...?

Pedantic, I know but there's a difference. And then there's your title, "stop a workbook from being saved if it has certain file name" - which is not mentioned in your post.

Regardless, I think you want to consider saving your file as a Template. That can contain code to prevent the workbook being saved if all the cells are blank plus the users will not normally save a template as a template so it will have to be renamed.

Confused yet?

Hi cytop,

Thank you for your reply.

I can see how someone could be confused on what I was asking for as my post was poorly written with very little info.
I'll have a second attempt in explaining what I meant.
We have a template data workbook called “sales data”, this workbook is used to collect information from other workbooks and outside sources. But before any information is meant to be entered and saved in this workbook the user needs to input the current date (21/06/2016) in a particular cell and select the “create new day” button. This button opens the save as function and saves a new workbook called “sales data 210616”.
The issue I am having is that some users entering data and are saving over the original template before enter a date and selecting the “create new day” button.
I was wondering is it possible to stop the workbook “sales data” from being saved but not the newly create workbook “sales data 210616”.