Adjust screen resolution automatically to fit all screen sizes

Good day 'Excel'lent folks,

I have created a a spreadsheet which is more of a 'dashboard' for users (multiple users..100s of 'em!) to view, analyse and tinker around within order to view varied results. Its full of graphs and ratings and other so-called 'cool' dynamic stuff. The worksheet opens in full screen and the scroll area is fixed thereby preventing accidental scrolling (left/right as well as up/down).

My problem is the sheet is designed to fit the screen size at a particular screen resolution (1366*768 which happens to be the highest resolution on my computer). If the worksheet is opened on a different computer/monitor with a different screen resolution, the layout does not fit properly. Graphs get cut off mid-way as all required rows and columns do not display in this new screen resolution.

Is there a way to fix this, so that the view that a user gets always fits his screen resolution settings and he can view all that he/she needs to?

Any leads would be much appreciated.

Cheers

I've used a combination of range selection and your above suggestion and it works quite well. Not perfect, mind you, but quite smooth. Thanks for your help!