I have specific problem.
I have some excel sheet, that I worked on a lot, so I could do labels and it was made for my old office printer like "perfectly".
Now I am in new office with a new printer, and that printer doesn't print in same layout like an old one, so margins of my excel sheet are "messed up".
Only way to make my excel sheet work, is to put my excel sheet on "1 page" via scale to fit height option.
I will make that, but is there any vba code to put that excel sheet in 2 modes via some button... Like one button is "height option to automatic" and second button "height option to 1 page"...
I have some excel sheet, that I worked on a lot, so I could do labels and it was made for my old office printer like "perfectly".
Now I am in new office with a new printer, and that printer doesn't print in same layout like an old one, so margins of my excel sheet are "messed up".
Only way to make my excel sheet work, is to put my excel sheet on "1 page" via scale to fit height option.
I will make that, but is there any vba code to put that excel sheet in 2 modes via some button... Like one button is "height option to automatic" and second button "height option to 1 page"...