Unhiding rows and columns in worksheets VBA

Hi,

I am trying to write the vba code that will unhide all rows and columns in a workbook if the worksheet colour is BLUE. is this possible?

i have 60 worksheets in the workbook - 20 of them are blue - these are the ones I want to unhide all rows and columns but dont want to have to write each name out.
any help wud be appreciated.
thx

What do you mean by worksheet colour? The colour of the cells? the tab? the background?

It would help if you could upload an example workbook, delete all the sensitive data and jsut have one of your blue sheets and one of your other sheets. It should be simple enough to do.

This assumes you are refering to Tab Color;

Please Login or Register  to view this content.

thx - this works great!