How to make a cell required before the user saves it

[BoomerSooner2014]

Hey guys...I have tried the following VBA code but its not working for some reason. I want cells J97:J99 required before the user can save it. The following code is what I tried:

Private Sub Workbook_BeforeSave(Cancel As Boolean)
If BusinessCase.Range("J97:J99").Value = "" Then
MsgBox "Cannot save until cells J97:J99 have been completed!"
Cancel = True
End If
End Sub


Let me know what I did wrong. I've attached the file as well. Q12013 Project Planning Template.xlsm

[Mumps1]

I can see a few issues that will create a problem. First of all, you have the code as part of the worksheet. It should be in the code window for ThisWorkbook. Also you are using merged cells which can create problems. As well, J99 is merged with H99 so when you click on J99 you will notice that it reads as H99. The line:

Please Login or Register  to view this content.

should read:

Please Login or Register  to view this content.

Try correcrting these problems first and see if that helps.

[BoomerSooner2014]

Thanks for the quick response, Mumps. I unmerged the cells and added the code in the ThisWorkbook window and I received the following error message:

Compile Error: Procedure declaration does not match description of event or procedure having the same name.

Any suggestions?

[Mumps1]

Try this code in ThisWorkbook:

Please Login or Register  to view this content.

[BoomerSooner2014]

That worked! Thanks again for your help!

[Mumps1]

Glad it worked out.