Easy Print macro needed
 

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

Easy Print macro needed
 

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

Easy Print macro needed
 

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

Easy Print macro needed
 

Hi FunkymonkUK

The report manager add-in is probably installed on your system but no
invoked (check in Tools Add-Ins, tick the box and click OK). If yo
decide to use it and other people are going to use the spreadsheet, yo
can force it to install on opening the spreadsheet by using a line as:

AddIns("Report Manager").Installed = True

in an auto exec macro.

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

Easy Print macro needed
 

how is the weather in your part of england?

London overcast and not really nice day.

I went to addins and saw a thing called Reports so clicked on it and i
said Cant find add-inn c:/progra
fiels/microsoft/office/library/reports.xla." delete from list?

Yes or no.

Do you have a copy of the reports manager

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

Easy Print macro needed
 

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

Easy Print macro needed
 

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

Easy Print macro needed
 

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