Trying to Print Preview Entire Workbook

J

Jrew23

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?
 
T

Trevor Shuttleworth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Print preview doesn't show all of the workbook pages to print in 2007 2
Preview Entire Workbook 1
Print entire workbook 4
Print Preview Problem 1
Duplex printing 7
Duplex Printing of Workbook with multiple worksheets 2
Print preview problems 5

Top