problem with footer when sent to pdf

hallingh

Well-known Member
Joined
Sep 11, 2010
Messages
769
I have the weirdest problem ever, and googling it didn't provide me with any related problems at all. I have a macro which generates a report and gets it print ready. In the footer I have the date on the left, the document name in the center, and the time on the right. When I print the document from Excel everything works fine, and when I send it to pdf everything works fine. However, I'm just constructing the program. The person who will actually be running the report macro and printing it out is on a different computer. When she prints it from Excel, the footer is fine, but when she gneerates a PDF the footer is absurdly tiny and flipped upside down. It is so small we first thought it was deleting it altogether.

This is by far the weirdest problem I have ever encountered. Anyone have any clue at all as to why this might be happening? Also, if you think that noone will be able to provide me with a solution to it (which wouldn't surprise me) it would be helpful to know that as well, because I can just put the date in the middle and be done with it.

Thanks for any insight you can give me.

Hank
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,224,552
Messages
6,179,487
Members
452,917
Latest member
MrsMSalt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top