Is there a way to pemanently turn off collation in Excel?

Thanks in advance for your help.

Sherry

What is collation?
Do you reefer to the Print Option?
If so, Uncheck the Collate Box.

Menubar

File Print...




"Sherry" wrote:

Is there a way to pemanently turn off collation in Excel?

Thanks in advance for your help.

Sherry

Yes, I refer to this. I was wanting to know if there is a way to do this
permanently so that I don't have to uncheck that box every time.

"exceluserforeman" wrote:

What is collation?
Do you reefer to the Print Option?
If so, Uncheck the Collate Box.

Menubar

File Print...




"Sherry" wrote:

Is there a way to pemanently turn off collation in Excel?

Thanks in advance for your help.

Sherry

Yes, I go to the Print dialog box and there is an option to uncheck Collate.
I was wanting a permanent way so that I don't have to uncheck this box every
time.

I was hoping that someone knew of a way to do this.

Sherry

"exceluserforeman" wrote:

What is collation?
Do you reefer to the Print Option?
If so, Uncheck the Collate Box.

Menubar

File Print...




"Sherry" wrote:

Is there a way to pemanently turn off collation in Excel?

Thanks in advance for your help.

Sherry

It is interesting that the option does not stay off, at least until you close
Excel!!

There may be something in the registry(RegEdit.exe) but I could not find it.

Create a toolbar button
Record a macro then uncheck the Collate box.

Assign this genearated code to yor Toolbar button.


- Mark

"Sherry" wrote:

Yes, I go to the Print dialog box and there is an option to uncheck Collate.
I was wanting a permanent way so that I don't have to uncheck this box every
time.

I was hoping that someone knew of a way to do this.

Sherry

"exceluserforeman" wrote:

What is collation?
Do you reefer to the Print Option?
If so, Uncheck the Collate Box.

Menubar

File Print...




"Sherry" wrote:

Is there a way to pemanently turn off collation in Excel?

Thanks in advance for your help.

Sherry