I have a workbook with a lot of sheets in it how ever I have a selection
of sheets names p1,p2,p3 right throught to p21. what i need is a macro
that selects only those sheets and prints it.

I tried the record macro and when I run it I get Dr.watson Excel
preformed illegal operation.

So need a quick and easy hand written macro.

Cheers :)


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=383483

Good afternoon FunkymonkUK

Have you tried using the Report Manager add-in? This adds an extra
item to the View menu and will do exactly what you want, and reports
designed this way are saved with the workbook.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=383483

hey dominicB

Good to see you still around,

What report manager is this, I am using xcel97. Other users will b
using this workbook

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38348

I found another way now i need a code.

If i click on fileprint.. it give an option at the bottom that say
print what and there is an option of entire workbook. which works as i
only prints out the visible sheets in the workbook which i want.

What would the code be do this

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38348

Hi FunkymonkUK

Whether here is fine and sunny, quite warm. Had a heavy downpour abou
half an hour ago but it's drying nicely now, but not like the scorcher
we had on Sunday and Monday.

Anyway, the code to do this is fairly simple:

ActiveWorkbook.PrintOut

Seems a bit too easy, but just had a play with it and it seems to wor
OK. BTW, check your private messages.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=38348

THANKS IT IS WORKING great. It does seem a bit to easy but least it
works

Not been a lot of rain in london for quiet sometime.

Oh yeah check you private message.
;)


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=383483