Prevent save unless all cells or certain cells are filled in

Hi all.

I have a spreadsheet that is emailed to someone to fill in. They then fill in some information and send it on to someone else.

Sometimes they don't fill in all the information so is it possible to have excel check that cells are filled in and to prevent someone from saving unless this is so? Or maybe a message stating that the cells need to be completed if Excel is being closed or saved?

First time on here. Any help would be greatly appreciated.

Thanks for the code VBA Noob! I do not use VB and the example you gave is for 1 cell. How would you put additional cells in?

Please Login or Register  to view this content.

or?

Please Login or Register  to view this content.

Cheers

Awesome! Thanks again for your help

Thanks Roy for that. It's a little easier than inputting all the cells as at least now I can select the ones I want to unprotect on the sheet.

They have now moved the goalposts however

Now It's not for when the sheet is saved but instead it's for when the user prints to PDF format.

Any ideas?

Thank you very much Roy! This worked perfectly except I just realized it stopped working when i use unlocked merged cells as part of those that have to be filled. One option is to unmerge them so they don't give me trouble, but it would change a lot of the format I want. Would you have any suggestion on how to make it work for merged cells? Thank you!!

I am useing office 2010 and it does not work when i try to save or save as.

Hi royUK

Thats fantastic! thank you. Is there anyway that the specific cells that must be updated to allow the save can be modified automatically according to the date?

I have a sheet that each day a number of different people enter details of sales etc for the day, but of course only details for that day. The next day the details of that day must be entered and so on.

Thank you very much

Richard

Hi royUK

Thats fantastic! thank you. Is there anyway that the specific cells that must be updated to allow the save can be modified automatically according to the date?

I have a sheet that each day a number of different people enter details of sales etc for the day, but of course only details for that day. The next day the details of that day must be entered and so on.

Thank you very much

Richard

Hello All,
I have a file (attached), in which I want the user to get a msg "All Fields are not filled" when they are trying to close ir save the file. I need help in writing a macro.
Requirement:- 1) In the file if the user fills the cell "R2" then he must fill the cell "S2" and "Y2".
2) In the file if the user fills the cell "R2" then he must fill the cell "S2" and "Y2". Also, if the user selects "Closed" in cell "Y2" then user must fill "Z2". The remaining cells can be left blank.

Please note that the user might not fill the cells in column "R". If the column "R" is empty then if the above mentioned cells are blank then user should not get the prompt that the "All Fields are not filled".
Also, the sheet will be used by the user every day and on day 1 the user might reach till "R20"..and all the other cells in the column "R" might be blank.. similarly, on day 2 the user might reach till "R40" and the cells below that will be empty.
Please let me know if you need more info on the requirement. Thank you in advance

Regards,
Shafi

Just wanted to say thanks and the info still helped in 2021