Hiding Coulums

[Guest]

Hi

I need to hide columns BU through to CA on each of 52 sheets I have in a
workbook.

Is there any way of doing on all sheets at the same time, thereby saving a
lot of extra work.

Cheers

 

[Guest]

Hi pjd,

This sounds like an Excel question. You should post your question to the
newsgroup(s) microsoft.public.excel (General Questions) and/or
microsoft.public.excel.programming.

As a start, I would turn on the macro recorder in Excel and record the
necessary mouse clicks to hide your columns. You can assign a shortcut key
combination to this macro. It should then run for every active worksheet, but
you'd have to select each sheet individually to run it. It is certainly
possible to include code that will interate all worksheets, but that's more
of a challenge than I'm up for at the moment. I'm sure an Excel guru would
know the answer.

Tom
___________________________________

:

Hi

I need to hide columns BU through to CA on each of 52 sheets I have in a
workbook.

Is there any way of doing on all sheets at the same time, thereby saving a
lot of extra work.

Cheers

 

[Guest]

Thanks

and you're right I ment to click on excel discussions. (it's been a long
day!!)

Cheers