After printing ,the macro works very slow

[yoav_b]

Thread has been locked for Cross Posting Here which is against forum Rules
Hello, I have a problem
I programmed a simple macro (attached to a button) that scan the lines in the sheet and uses the function:
Cells(y,2).EntireRow.Hide=TRUE (in order to hide certain lines)

Usually, It runs fast without problem. But when I print out an area of the sheet, it cause the macro to slow down substantially. (when it runs again)

In order to fix that , I need to close the file and reopen it again ( and not print out)

Does anybody familiar with this problem?

I'll be most grateful to any help or suggestion.