Easy Print macro needed

[funkymonkUK]

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

 

[dominicb]

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

 

[funkymonkUK]

hey dominicB

Good to see you still around,

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

 

[dominicb]

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

 

[funkymonkUK]

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

 

[funkymonkUK]

I found another way now i need a code.

If i click on file>print.. 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

 

[dominicb]

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

 

[funkymonkUK]

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.