Unhide all columns and rows hidden

[RJ1969]

Hi
I had this code and when I run it in macro in only unhide the columns hidden but not all the rows that is hidden in Sheet2.

Thank you.

Please Login or Register  to view this content.

[RJ1969]

I think I figure it out :o)

Thanks.

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

Notice the red dots in front of Columns and Rows. If you don't use them in a With ..... End With structure you will still be refering to the Active sheet instead of Sheet2

[RJ1969]

Hi Bakerman,
I tried to include Sheet3 and Sheet4. This is what I come out with but it looks like its not working.

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

[RJ1969]

Hi Bakerman2
I see what I missed :o)

Thank you.

[bakerman2]

You're welcome and thanks for rep+.

[RJ1969]

Hi Bakerman,
Do you think you will be able to fix this for me? Thanks.

Please Login or Register  to view this content.

[bakerman2]

Depends on what you are trying to achieve.

[RJ1969]

Hi
I was trying to do a macro.

Here is the scenario.

The macro will print preview tje document (sheet2) for about 5 seconds and after 5 seconds then it will automayically close preview and will return to editing documents (sheet2).

Thanks

[RJ1969]

Hi Bakerman

In addition,
This scenario is Without printing the document. Just “print preview” for 5 secs then Return to sheet2 documents.

Thanks

[bakerman2]

Not possible.

Code execution is suspended while in PrintPreview window so you will have to close manually.

[YasserKhalil]

I have searched for such a topic and didn't find answer. The code suspends till the preview closed manually ..

[RJ1969]

Hi Bakerman2
Ok :o( .......
I thought so too but I just need to hear from the expert :o)

Thank you again

[RJ1969]

Thank you too YasserKhalil