On worksheet, I have few hidden rows which I unhide through VBA
clicking on a button. Also on worksheet 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. Like Before PrintPreview
event.

Thanks in advance