Trying to Print Preview Entire Workbook

Hi,

I'm trying to view all the tabs of a workbook by selecting:

File | Print | Print What: Entire Workbook | Preview

but when i choose "Entire Workbook", the Preview button is dimmed and I
cannot select it.
I've used this method before, and it's worked, but now it doesn't.

When "Acive Sheet(s)" or "Selection" is selected the preview is
undimmed.

Why is this happening?

Select all the sheets first and then go for your Print Preview. Select the
first sheet and then shift/Click on the last sheet to group the sheets.

Regards

Trevor


"Jrew23" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm trying to view all the tabs of a workbook by selecting:
>
> File | Print | Print What: Entire Workbook | Preview
>
> but when i choose "Entire Workbook", the Preview button is dimmed and I
> cannot select it.
> I've used this method before, and it's worked, but now it doesn't.
>
> When "Acive Sheet(s)" or "Selection" is selected the preview is
> undimmed.
>
> Why is this happening?
>