Stopping user saving unless condition met.

Sorry to be back so soon.

I am looking to stop the user saving the sheet if certain fields are not complete.

The sheet has headers on line 4 and runs from A4 to M500

In the M cells there is a counta function to check the records are complete.

M4:M500 shows either

Complete - All records comlpete
Incomplete - something missing
Blank - nothing entered yet.

What i want to do is, if one of the cells in M shows incomplete not allow them to save the sheet until its complete.

I tried the folowing (was my attempt to modify another post)

Please Login or Register  to view this content.

Any help appreciated.

Thanks again.

Originally Posted by VBA Noob

Maybe

Please Login or Register  to view this content.

VBA Noob

Sorry think i may have not explained that as well as i could.

when i say "blank" above the cell shows the word blank due to the following IF statement.

Please Login or Register  to view this content.

tried changing the code to

Please Login or Register  to view this content.

But sadly a little knowledge is dangerous and it didnt work!

Is the problem the fact the M cells are the product of an IF statement?

Originally Posted by VBA Noob

Maybe

Please Login or Register  to view this content.

VBA Noob

Sadly no, still allows saving even tho there are a few "Incomplete" records.

Thanks for your help tho.

Is it allowed to post a dump of the screen to show my sheet?

spi04x - asc - report_3sheet_gsearchpost.zip

Thanks

Its the ASC sheet tab.

had to delete one of the tabs Complaint_ASC to make it fit so pls ignore any error due to that.

Sorry about that! ive moved it but now get.

Compile Error
Variable not Defined

and then it highlights

msg =

Sorry to be such a pain.

done as you said and removed the line re "blank" and works perfectly

Thanks VERY much four help, really apprecate it.

And the fact you managed to remain patient!

Please Login or Register  to view this content.