Good morning. I am new to this site but was hoping someone might be able to help me.

I have an application written in VBA in Excel. I have created a new report (workbook) that has various radio buttons on it. These buttons have VBA code behind them to hide certain rows & columns based on certain criteria. Everything works well except after I print the workbook, preview the workbook or or do anything that has to do with printing. Once I do anything having to do with printing the macros that get run from the click events of the radio buttons slow down to a snails pace. They still work properly but literally take 5 to 6 times the amount of time as they did prior to printing. If I shut down Excel and bring it back up the macros start flying again. Is anyone aware of this issue or ever experienced this. I am not sure why printing would permanently slow down my macros until I close and re-open the workbook. Any help or advice anyone could give would be greatly appreciated.

Thanks.
MRAAdam

Here's the code:

Sub optResComOnly_Click()
Dim Cell As Range
Dim sOverallView As String
Dim sLocation As String

sLocation = ActiveCell.Address

application.ScreenUpdating = False
Worksheets("Hidden").Range("SelectedBusSeg").Value = "ResComOnly"
sOverallView = Worksheets("Hidden").Range("OverAllView").Value

For Each Cell In Range(sOverallView)

Cell.EntireRow.Hidden = False

If Cell.Value <> "Visible" Then _

Cell.EntireRow.Hidden = True
End If
Next

Set Cell = Nothing

HideZeroRows


application.ScreenUpdating = True
ActiveWorkbook.ActiveSheet.Range(sLocation).Select
End Sub
---------------------
Sub HideZeroRows()
Dim Cell As Range

For Each Cell In Range("ZeroRows")

If Cell.Value = "X" Then
Cell.EntireRow.Hidden = True
End If
Next

Set Cell = Nothing

End Sub