Print Titles

[tek9step]

Hi guys /gurls.. I have multiple sheets (approx 200) with similar data structure what i would like to do is highlight top 3 rows for each sheet as Print Titles for all sheets.. Im sure this looks impossible..but not sure if anyone has cracked it..

thanks...

[tek9step]

No mate u cant do that either.. Print title gets greyd out if i select more than 1.. not sure whether there is a solution for this

[tek9step]

i will look fwd to see if there is a solution if so that would be great ... thanks !!

[tek9step]

fair enough !!

[martindwilson]

try this macro(see bottom of this post for where to put code)

Please Login or Register  to view this content.

then go to tools macro/macros
select "settitle" and click run
this will repeat rows 1,2,3 of each sheet at the top of each page in each work sheet

[tek9step]

Thanks martin thats great

[mudraker]

Stormseed

Thanks for pointing out this thread was crossposted