I have code that will give a specific cell value based on if a row is hidden or not
If Worksheets("Sheet3").Rows("10").EntireRow.Hidden = True Then
Worksheets("Sheet3").Range("F8").Value = "Underwriting File View Off"
End If
If Worksheets("Sheet3").Rows("10").EntireRow.Hidden = False Then
Worksheets("Sheet3").Range("F8").Value = "Underwriting File View On"
End If
The code works, however the rows are hidden/unhidden based on a Command Button. The cell value does not change until click or tab to a different cell on the sheet. I'd like it to change as soon as I click on the command button without having to click onto a different cell. Are there any suggestions on how I could do this better?
Thanks!
If Worksheets("Sheet3").Rows("10").EntireRow.Hidden = True Then
Worksheets("Sheet3").Range("F8").Value = "Underwriting File View Off"
End If
If Worksheets("Sheet3").Rows("10").EntireRow.Hidden = False Then
Worksheets("Sheet3").Range("F8").Value = "Underwriting File View On"
End If
The code works, however the rows are hidden/unhidden based on a Command Button. The cell value does not change until click or tab to a different cell on the sheet. I'd like it to change as soon as I click on the command button without having to click onto a different cell. Are there any suggestions on how I could do this better?
Thanks!