-
Jun 11th, 2020, 07:54 PM
#1
[RESOLVED] Don't scale when printing
If I were to guess I'd say this isn't possible but what I'd like to be able to do is to print the first 5 columns of my worksheet and have them not scale bigger. In my code I've set the print area width to be the first 5 columns, and the length to be the last row. When I print it it scales the width of the first five columns up so that it fills the width of the page. Is there any way to stop that from happening?
-
Jun 12th, 2020, 06:37 PM
#2
Re: Don't scale when printing
-
Jun 12th, 2020, 07:41 PM
#3
Re: Don't scale when printing
My zoom is 100%. The problem is that the total width of the 5 columns is less that a full page width so Excel scales up the width to fit the width of 1 page. I think that if I hide the columns to the right that contain data and then print more columns,
-
Jun 13th, 2020, 03:50 AM
#4
Re: Don't scale when printing
did you try set to pages tall?
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Jun 13th, 2020, 08:25 AM
#5
Re: Don't scale when printing
-
Jun 15th, 2020, 09:22 AM
#6
Re: Don't scale when printing
Or change the margins so that there is no room left to scale.
-
Jun 15th, 2020, 10:08 AM
#7
Re: Don't scale when printing
Thank you for the suggestion. It turns out that my workbook was corrupted and had several print areas that I couldn't remove or repair and I had to rebuild the workbook.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|