View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_1139_] Simon Lloyd[_1139_] is offline
external usenet poster
 
Posts: 1
Default Printing multiple workbooks


Useless;350305 Wrote:
Hey all,

I'm new to this site and have search for some considerable time to find
the answer with no avail.

I have 4 individual workbooks that all link together through formulae
and each workbook has around 20 tabs. For purposes of this the workbooks
are section 1, section 2, section 3 and total. I have put in some
hyperlinks in total to link to the other 3 workbooks but want to have a
link that will firstly print all tabs in section 1, section 2 or 3
depending which one is chosen and secondly print all tabs on all
workbooks.

I'm new to VBA bar failing it miserably at AS level but have a good
grasp of excel.

Many thanks in advance for help.

GrahamGraham, welcome to The Code Cage!, your lucky you found us today as we

have just moved server :)

Do you want to print all sheets from all workbooks?, i'm not exactly
sure what you want!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97998