Hello -
I have a workbook that the user will select Y/N on the "Overview" tab. This triggers a true / false if statement on the "Benefits" tab. I have a macro running on the benefits tab that will hide all rows with False in column D (See below) and only the appropriate benefits will remain showing.
Sub Worksheet_Calculate()
Dim Cell As Range
Application.ScreenUpdating = False
Application.EnableEvents = False
For Each Cell In Range("D3:D700")
Cell.EntireRow.Hidden = Cell.Value = False
Next
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub
This macro works fine. The issues is when I go to either print, set the page breaks, or print preview, the macro will run extremely slow thereafter. I believe the problem is is that excel is calculating page breaks from D3 to D700. Anyone no I can I avoid this?
Thank you
Bookmarks