If you were to read ALL the text on the site you posted below you would find a
link to obtaining the HotFix from MS support.
To resolve this problem immediately, contact Microsoft Product Support Services
to obtain the hotfix. For a complete list of Microsoft Product Support Services
telephone numbers and information about support costs, visit the following
Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note: also carefully read the part about prerequisites for installing the HotFix
Gord Dibben MS Excel MVP
On Sat, 17 Mar 2007 13:44:00 -0700, excel-tr
wrote:
hi,
Run-time error '1004':
"Unable to set the PrintQuality property of the PageSetup class."
when I run the below code, I get above error, for this there is hotfix but
from where I can download it ?
http://support.microsoft.com/kb/903246 no file in this link
Sub SetPrintQuality()
For Each xSheet In ActiveWorkbook.Sheets
xSheet.PageSetup.PrintQuality = 300
Next xSheet
End Sub