cell value based on hidden and un-hidden rows

[lawrebw]

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!

 

[Jeffrey Mahoney]

It sounds like you have the the code in a SHEET level module and it runs when you select a different cell. You need to copy that code into the Command Button code.

I wouldn't have that code to run each time you select a different cell. It bogs down the system.

 

[lawrebw]

You were right. That was the problem. Thanks!