I have a spreadsheet which runs fine whenever i run it.  whenever someone 
runs it, they get an error on :   .PrintQuality = 600 and says unable to set 
the print quality property of the page setup class.  i compared her 
option/setup and all is the same as what i have.  any suggestions on why the 
person is getting this error?

Thanks for your help!

That sounds like something that would be dependent on the capabilities of the 
print driver for the default printing device. If you (or she) manually sets 
up a document to print, what is the default printer, and what is it's highest 
available resolution? Most modern printers allow for higher resolution, but 
older printers, generic print drivers, or "electronic document" print drivers 
may be limited to a lower number (300?).

Possible workaround: 
<code>
..printquality = 300
on error resume next
..printquality = 600
on error goto 0
<code>

HTH,
Keith

"Miskacee" wrote:

> I have a spreadsheet which runs fine whenever i run it.  whenever someone 
> runs it, they get an error on :   .PrintQuality = 600 and says unable to set 
> the print quality property of the page setup class.  i compared her 
> option/setup and all is the same as what i have.  any suggestions on why the 
> person is getting this error?
> 
> Thanks for your help!
> 

You could ignore the error (on error resume next) or try to work around it (like
Keith shows).

Or you could just weasel out and assume that most print jobs won't need to be
told the .printquality property (just drop the line from your code).

You may want to be more concerned with margins.  I try to make them as wide as I
can for the worst(!) possible printer I could imagine.

Miskacee wrote:
> 
> I have a spreadsheet which runs fine whenever i run it.  whenever someone
> runs it, they get an error on :   .PrintQuality = 600 and says unable to set
> the print quality property of the page setup class.  i compared her
> option/setup and all is the same as what i have.  any suggestions on why the
> person is getting this error?
> 
> Thanks for your help!

-- 

Dave Peterson

To follow up on Dave's comment, my workaround actually wasn't thought out 
well enough. It may be possible that some print driver simply doesn' accept 
any value you'd want to set, so you'd want both lines within the 
error-ignoring lines (see correction below). Still, if it isn't required, 
then like Dave said, see if you can just drop it altogether...

Possible workaround: 
<code>
on error resume next
..printquality = 300
..printquality = 600
on error goto 0
<code>


"Dave Peterson" wrote:

> You could ignore the error (on error resume next) or try to work around it (like
> Keith shows).
> 
> Or you could just weasel out and assume that most print jobs won't need to be
> told the .printquality property (just drop the line from your code).
> 
> You may want to be more concerned with margins.  I try to make them as wide as I
> can for the worst(!) possible printer I could imagine.
> 
> Miskacee wrote:
> > 
> > I have a spreadsheet which runs fine whenever i run it.  whenever someone
> > runs it, they get an error on :   .PrintQuality = 600 and says unable to set
> > the print quality property of the page setup class.  i compared her
> > option/setup and all is the same as what i have.  any suggestions on why the
> > person is getting this error?
> > 
> > Thanks for your help!
> 
> -- 
> 
> Dave Peterson
> .
>