Excel Display & Print Options

johnb1979

New Member
Joined
Dec 9, 2019
Messages
37
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
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,889
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
 

Watch MrExcel Video

Forum statistics

Threads
1,127,847
Messages
5,627,239
Members
416,232
Latest member
Ash1432

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
Top