Print entire workbook but without first two sheets.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMac - 28 Jan 2008 18:41 GMT

I need to print a workbook with a variable number of worksheets.
However, I don't need the first 3 worksheets of the book. It also
needs to be collated. I need to create a macro or VB loop to make it
automatic from a command button. Any ideas?

Thanks in advance,

Josh

Reply to this Message

FloMM2 - 02 Feb 2008 22:38 GMT

JMac,
Assuming the first three worksheets are only one page long each.
Try this:
After you have added your command button.
Enter "Design mode".
Select button, view code.
After Private Sub CommandButton1_Click()
Type the following:
ActiveWorkbook.PrintOut (Page4), Collate = True
Close and save.
Give it a try.
hth

:-)

> I need to print a workbook with a variable number of worksheets.
> However, I don't need the first 3 worksheets of the book. It also
[quoted text clipped - 4 lines]
>
> Josh

Reply to this Message