VBA Check for interior cell color before close

[Pinaceous]

Hi All,

I'm working with a

Private Sub Workbook_Close()

code, where I would like to provide the code to check for an interior cell color red in the range of B11:AI180.

I was experimenting with the following but I cannot make it work.

Dim response As VbMsgBoxResult
response = MsgBox("Highlighted cells are found on your sheet.  Do you want them to be corrected", vbYesNo)

   If response = vbYes Then
    MsgBox "Please make the corrections."
  Exit Sub

   If response = vbNo Then
     'MsgBox "Continues to close document."
   Exit Sub

End If

Do you think you can help?

Many thanks!
-Pinaceous

 

[Pinaceous]

Wow Thanks jolivanes!

That was perfect!

 

[jolivanes]

Glad it works for you and thank you very much for letting us know.
Good Luck