Thread: setprintquality
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excel-tr excel-tr is offline
external usenet poster
 
Posts: 37
Default setprintquality

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
--
SAHRAYICEDIT-ISTANBUL