is the equivalent of what I posted.![]()
With ThisWorkbook.Sheets("CommissionTest") If .Range("A18").Value = "" Then .Buttons("CommissionMacro").Enabled = True .Buttons("CommissionUpdate").Enabled = False Else .Buttons("CommissionMacro").Enabled = False .Buttons("CommissionUpdate").Enabled = True MsgBox "The Agencies tab needs to be updated." & vbNewLine & vbNewLine & "Please select the Update Agencies tab button" End If End With
Bookmarks