A macro setting that would cause a Run-time error

**westonkw** · 05-06-2009, 02:28 PM

Is there a setting within excel that could cause a user to get a run-time error 1004? I have a workbook with a macro that adds additional sheets to the workbook when a button is clicked. The thing works fine on my machine and 3 or 4 other machines that I have had guys test it out, but I have a user that it will not work for. He is at a location about 3 hours away so I cant see exactly what he is doing, but he says after he clicks the button he gets a run-time error 1004 that says "Unable to set the PrintQuality property of the Page Setup class". I'm thinking that it is a setting within excel? Any ideas?

**royUK** · 05-06-2009, 02:39 PM

Is he using a different version of Excel?

**Chance2** · 05-06-2009, 02:45 PM

Does he have a default printer setup on his system? Sometimes if the MSFAX (default) or no printer installed you may get this error.

**shg** · 05-06-2009, 03:21 PM

From Help:

PrintQuality Property
Returns or sets the print quality. Read/write Variant.

expression.PrintQuality(Index)
Index Optional Variant. Horizontal print quality (1) or vertical print quality (2). Some printers may not support vertical print quality. If you don’t specify this argument, the PrintQuality property returns (or can be set to) a two-element array that contains both horizontal and vertical print quality.

**westonkw** · 05-08-2009, 09:34 AM

He is using the same version of excel.

I think the MSFAX thing may be an issue? I sent him an email asking what he is using for a printer waiting for a reply.

Do you think If he switches his default printer this may take care of the issue?

And if that is the problem is there a way to rewrite the code to eliminat the issue with this type of printer?