spreadsheet to adapt to window size

I have data within my worksheets and want all the data to be viewed without the need to scoll horizontally or vertically. So dependant on the screen size of the monitor or the window size the user has the workbook open at i would like the information within the workbook to adapt to this. I take it if the window gets to a very small size then scrolling would be necessary.

The reason for my question is if the user opens the workbook on a 13 inch monitor the data within the workseets would adapt to be able to fit all the data on the screen. Whereas if the data was opened on a 22 inch monitor it would increase the size of the data within the worksheet, would adapting the zoom function dependant on the screen resolution be the way to do this?

I hope this is understandable, if not please reply back so i can try and explain myself more precisely.

Thank you and I look forward to your reply.

See if link helps

http://www.vbaexpress.com/kb/getarticle.php?kb_id=32

VBA Noob

If one user is the problem as them to set a custom view maybe.

VBA Noob