Hi,

I have few worksheets in a workbook.
On first worksheet, I have some hidden rows which I can unhide with VBA
clicking on a button. Also I have set print area, so when I click on a
button, rows becomes unhidden and prints. After printing, rows becomes
hidden again.

Is it possible that when I click on Print preview, that rows also unhide and
after Closing Print preview becomes hidden again.

If someone can help?
Thanks in advance