How to make a number of cells mandatory if another cell is populated?

[MW_BAH]

Hi everyone - newbie to the forum here looking for some help

I have a sheet where I want to make certain cells in a row mandatory if a specific cell in the same row is not blank. For example, if B1 is not blank then cells C1, D1, E1 and M1 must be filled in. I would need this to apply to every row on the sheet and display an error message before save and close if any of the mandatory cells are blank, unless of course column 1 is blank. All cells would be free-type and not using drop downs.

I understand I can probably use VBA to do this but have no idea what code to use so would appreciate any advice and step by step guidance on how to do this.

Thanks!

 

[pjmorris]

Hi, sorry for delay in replying, for some reason our iCloud access froze and I didn't see any emails.

What has happened is that when the command

Application.EnableEvents=false

has been executed and the 'End or Debug' message occurred the code didn't get to the matching

Application.EnableEvents=True

.

In a code module put:

Sub ResetMacro()
   Application.EnableEvents=True
End Sub

If you get the error again you can run that macro to restart the events handling.

When the 'End or Debug' message occurs can you select Debug and then take a screen shot of the code and line with the error. It is likely to be a conflict or error in sheet names or something similar.

HTH.