Excel Display & Print Options

johnb1979

Board Regular
Joined
Dec 9, 2019
Messages
50
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have an excel form that I store in One Drive for use by several people. When it's opened on a laptop and printed out, the setting change and the page breaks alter so the information is spread over more pages than needed, but if the same form is opened on a desktop, the form is fine. I'm aware that the display settings on the laptop and PC can be different but I can't alter them to match due to health & safety (eye straining etc) - I just wondered if there was a way of fixing the form so it automatically alters to suit either application and prints out as it needs to.

Sorry if this is a bit vague but any help would be greatly appreciated.

Thanks in advance
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
If the userform is too small for the laptop, you could build a smaller one that is designed for the smallest laptop screen (hopefully no one is using a smartphone). Then when the form should be displayed use the following to determine the monitor width in Pixels to choose which form to use:

VBA Code:
Function ReturnScreenWidthInPoints() As Single
    
    With Application
        .ScreenUpdating = False
        .WindowState = xlMaximized
        ReturnScreenWidthInPoints = .Width
        .WindowState = xlNormal
    End With

End Function
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

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