Error message

  • Thread starter Thread starter allipops
  • Start date Start date
A

allipops

I have purchased a program in excel and I am getting the followin
message when I use the macro:-
Runtime Error ‘1004’ unable to set the printquality property of th
pagesetup class

The programmer has not got back to me yet other than to advise me t
lower my sercurity settings in macros which has not helped.

Does anyone have any idea what I can do.

Thanks.:rolleyes
 
This may?? help or perhaps your excel version doesn't support?
PrintQuality Property
See Also Applies To Example Specifics
Returns or sets the print quality. Read/write Variant.

expression.PrintQuality(Index)

expression Required. An expression that returns a PageSetup object.

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.

Example
This example sets the print quality on a printer with non-square pixels. The
array specifies both horizontal and vertical print quality. This example may
cause an error, depending on the printer driver you’re using.

Worksheets("Sheet1").PageSetup.PrintQuality = Array(240, 140)This example
displays the current setting for horizontal print quality.

MsgBox "Horizontal Print Quality is " & _
Worksheets("Sheet1").PageSetup.PrintQuality
 
Lowering the security settings won't help. Once you've allowed macros to run,
that setting doesn't do anything. And you've allowed macros to run, since
you're getting that message.

My guess is that the developer used his printer settings when he created the
macro. Most printers share many common settings, but there are some printers
that don't have settings that other printers have.

I'm guessing that his macro tries to make a change to a setting that your
printer doesn't support. If you can see the code that causes the error, you may
be able to just comment that line--so it doesn't do anything (good or bad).

But if the code is protected, the developer will have to make the change and
give you a new file.
 
Back
Top