Duh. Leave it to me to forget the obvious.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:uDB%230S66FHA.2036@TK2MSFTNGP14.phx.gbl...
> If you select all sheets all the things you do in one sheet will be done
> in
> all the sheets, don't forget to ungroup the sheets when you are done
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "nicolebelle" <nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com>
> wrote in message
> news:nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com...
>>
>> Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
>> have the same headings (there are about 10 headings) underneath each
>> heading i have my drop down list (validations) that people need to
>> choose from. i need to format my whole gigantic worksheet like this,
>> but right now am only doing it 1 at a time (which is taking
>> forever!!! ) Does anybody know how to do this?? this is my first
>> time and there has got to be an easier way...any help would be greatly
>> appreciated!! thanks!
>>
>>
>> --
>> nicolebelle
>> ------------------------------------------------------------------------
>> nicolebelle's Profile:
> http://www.excelforum.com/member.php...o&userid=28847
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=485968
>>
>
>