Excel printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikieSlats - 30 Sep 2007 06:41 GMT

In printing in Excel the "Print What" defaults to "Active Sheets". It used
to default to "Selection". Any suggestions as to how I can get the default
back to how it was?
Michael

Reply to this Message

Jim Rech - 30 Sep 2007 23:08 GMT

>> It used to default to "Selection".

I really don't think that is true, Michael. The VBE is smart enough to do
that but I do not believe Excel has ever defaulted to printing the selection
when more than one cell is selected when the Print dialog is opened. If
this is something you need it wouldn't be hard to write a macro to handle
it.

Signature

Jim

> In printing in Excel the "Print What" defaults to "Active Sheets". It
> used
> to default to "Selection". Any suggestions as to how I can get the
> default
> back to how it was?
> Michael

Reply to this Message

GreyGoose - 01 Oct 2007 01:16 GMT

>>> It used to default to "Selection".
>
[quoted text clipped - 3 lines]
> this is something you need it wouldn't be hard to write a macro to handle
> it.

If you are sharing a computer, sometimes the person before you will use
that selection and the computer didn't go back to the default.
Otherwise, the printer has always used the Active sheet(s) when printing
worksheets.

Reply to this Message

Jim Rech - 01 Oct 2007 14:49 GMT

>>sometimes the person before you will use that selection and the computer
>>didn't go back to the default.

That's not true in my tests. The second time I open the Print dialog it is
set back to Selection.

Signature

Jim

| >>> It used to default to "Selection".
| >
[quoted text clipped - 8 lines]
| Otherwise, the printer has always used the Active sheet(s) when printing
| worksheets.

Reply to this Message