Making a worksheet fit to the screen

[scotthannaford1973]

Hi

okay - I have a worksheet that acts as a landing page to a huge workbook and I'd like it so that the pretty area of the worksheet (lets say A1:Q29) automatically fits to the size of the screen. The problem there is that some people use laptops and some desktops - so the resolution and screensizes are different for everyone.

Is there a VBA way to state that this worksheet range, when the sheet opens, defaults to the height of the viewable area? or similar?

TIA

 

[daverunt]

Any use

How to resize Excel sheet - 4 ways: manual & automatic

Dashboards should be contained in one screen, but what if we don't know the size of the monitor? Find out How to resize Excel sheet automatically.

exceloffthegrid.com

and

How to Auto-Fit active screen to fit all sizes of screens

Hi, I have an opening 'Home' sheet of my dashboards that I made to exactly fit the screen (Cells A1 to M22). im working on my 14" screen laptop. when I shared the file with my boss who opened it on his gigantic desktop screen, we could see the cells to the right and bottom of my opening page...

www.mrexcel.com

 

[scotthannaford1973]

well that's annoying so easy! what the hell was I googling?!

cheers

 

[daverunt]

Gives me something to do though.
Cheers.