I have a short piece of vba that includes
With ActiveSheet.PageSetup
.
.
.
.PaperSize = xlPaper11x17
.
.
.
End With
It ran a few times when I was debuging but then I closed the vba editor and ran if from a toolbar button and I get
Error 1004 Unable to set the PaperSize Property of the PageSetup Class
It's done this ever since. If I comment out the .PaperSize = xlPaper11x17 it works fine.
The default printer is a big copier that handels A, B and legal paper and there are several other printers installed including pdf printers so it's not like it can't be printed on installed hardware.
Any ideas?
Thanks,
C DeWitt
With ActiveSheet.PageSetup
.
.
.
.PaperSize = xlPaper11x17
.
.
.
End With
It ran a few times when I was debuging but then I closed the vba editor and ran if from a toolbar button and I get
Error 1004 Unable to set the PaperSize Property of the PageSetup Class
It's done this ever since. If I comment out the .PaperSize = xlPaper11x17 it works fine.
The default printer is a big copier that handels A, B and legal paper and there are several other printers installed including pdf printers so it's not like it can't be printed on installed hardware.
Any ideas?
Thanks,
C DeWitt