How can I control the zoom so the user will only see the frozen panes?

[USAMax]

I have a main screen with several controls that I made look very nice with all the clients colors and what not.

There will never be anything on the worksheet outside of A1 to E20 that they will ever need to see. I zoomed out to F21 and froze the panes and zoomed back in. My zoom is set to 170%.

Two things that I want to do are:
1) Set the appropriate zoom based on the user's screen resolution.
2) Prevent the user from zooming out beyond the Frozen Panes.

Thank you,

 

[RoryA]

Rather than messing with Zoom settings and screen resolutions, can you not either hide the rest of the rows and columns, or put that data onto a different sheet?

 

[USAMax]

Wow Rory, you got back to me in record time.

There isn't anything else on the sheet. I just want a static sheet that they cannot scroll away from. I did not know you could hide every row and column on the worksheet except for the ones you want. Never heard of that and never thought of that.

I had to try it and it is amazing! Looks just the way I wanted but with one minor issue. If the user zooms out so they see more than I want them to see the screen is very sluggish. Just zooming out once freezes the program for about a full second or more.

I still like it, neat trick!