Hiding the same column on multiple sheets

Hi,

I have a macro that performs the same actions to an array of sheets. I need to be able to hide a column on all of the tabs, but if I hide the column on the activated sheet while the array of sheets is selected, it only hides that column on the activated sheet. Is there a way to hide that column on all of the sheets?

What may complicate the issue is that the array of sheets that are selected is dynamic and will change as more sheets are added. Also, the column that will be hidden will change. The hidden column is specified by a value in cell b11 of each sheet that has the column number that needs to be hidden. I really appreciate your help, you guys (and or girls) really amaze me sometimes. Thanks!

Originally Posted by Shijesh Kumar

Here is a sample code for you

It hides the column specified in cell "B11" of all the sheets in the work books.
You can ammend it to hide the columns of the sheet you want to hide..
In B11 enter the column you want to hide eg... D , E , F or so on

Please Login or Register  to view this content.

OK, this is going to work, and really well, but I have the column number in cell B11, I can probably adjust it to return the letter code, but it will be alot easier and better on memory if I can just use the column number instead. Is it possible? Also, do I have to adjust the portion where it says "sheet1" to be one of my sheets before I run the macro? Thank you SO much!

WAIT! Nevermind, I figured it out. Thank you so much for your help, I cant express how much this helps me!

I was wondering what if your workbook has 5 sheets and you only want to apply this macro to only 4 of them?
Thanks