Disable Saving Until All Mandatory Fields are Populated - Cant get it to work!!!

Please Login or Register  to view this content.

You need to delete this line:

Sub MandatoryFields()

Also, for clarity and to comply with the Forum rules, please place your code between the hash marks # #

Thank you, Logit.

I deleted the line and it deleted the entire macro. I had named the macro "MandatoryFields", which is why I think that happened.

Do I have to name the macro "Workbook_BeforeSave" for the code to work?

Thanks again.

Please place your example code in the # # marks. In the QUICK REPLY screen there are menu tools you can select. Look for the hash mark and click it.
You'll need to use EDIT POST on your posting #1 to do this.

Your code needs to go in the ThisWorkbook module of your workbook.

This macro module:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

is restricted to that portion of your workbook.

It works! thank you!!!!

You are welcome.

Thank you for changing your original post.

Cheers