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.

Graham


--
Useless
------------------------------------------------------------------------
Useless's Profile: http://www.thecodecage.com/forumz/member.php?userid=330
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97998

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

Sorry, yes i want to print all worksheets from each workbook when that
workbook is selected.

My 'plan' is to have text in 4 seperate boxes that says 'print section
1', 'print section 2', 'print section 3', 'print all' at which it will
automatically print all worksheets in the selected workbook, or as in
'print all' case print all worksheets from all 4 workbooks.

Hope this explains it better.

Graham


--
Useless
------------------------------------------------------------------------
Useless's Profile: http://www.thecodecage.com/forumz/member.php?userid=330
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97998