Excel printing

[Guest]

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

 

[Jim Rech]

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.

 

[GreyGoose]

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.

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.

 

[Jim Rech]

sometimes the person before you will use that selection and the computer
That's not true in my tests. The second time I open the Print dialog it is
set back to Selection.

--
Jim
| Jim Rech wrote:
| >>> 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.
| >
| 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.
|