Restore Hidden/ Visible rows and columns

[plans]

Hello,

I have a worksheet which contains numerous hidden rows and columns.
The hidden rows and columns are not continuous, for example, it could have rows 5, 8, 12 and columns b, g, aa hidden.
I am wondering if there is an easy way to have a :
Script1: which could record the current configuration of the entire worksheet; I could use a worksheet within the workbook, specifically created for this purpose which could hold the record of the hidden rows and columns.
Script2: which could read the record created above and restores the spreadsheet to the original configuration.


Thank you

[ORoos]

Hi there,

Give the below a try. You can set up a button for trigger each script separate.

Please Login or Register  to view this content.

[plans]

ORoos,
Thanks for the response.
This is not what I am after..
I want to be able to restore the current worksheet configuration after I made changes to it.
That is why I need to record (in Script1) the Visible/Hidden rows, columns, so I could use that info to restore the layout in Script2; or.... perhaps, there is a better way to do it?
Thanks

[ORoos]

Hi there,

Please see attached file.

There are some rows and columns hidden.
Run the first macro = all cells and rows are visible.
Run second macro = all rows and cells originally hidden (before first macro)will be hidden again, restore layout.

[plans]

Thank you ORoos!

[ORoos]

Thanks for the Rep

If this answered your query, please mark it as SOLVED via the Thread Tools at the top of your original post.

Cheers,