Cheers Oz

That will work but seems very inefficient when all the sheets are
already selected. If I manually select hide columns with multiple
sheets selected it hides them on all the sheets.

If I then record that same action and play it back it only does the
active sheet. I have approximately 20 workbooks each with different
sheet names that this code has to be applied to so activating each
sheet and then executing the code will be a very time consuming process
to code and to execute.

Surely their is a way to execute the code on all the sheets highlighted
without having to activate each sheet in turn??

Shad


--
Shadster
------------------------------------------------------------------------
Shadster's Profile: http://www.excelforum.com/member.php...o&userid=24610
View this thread: http://www.excelforum.com/showthread...hreadid=381964