Is it possible to automatically control zoom level so resizing a window doesn't hide anything?

M

Marvin Hlavac

Is it at all possible to automatically control zoom level so when I resize
XL window no cells will be hidden from my view. For example in my worksheet
I want to be able to see at all times A1:H22. When viewed on a computer
monitor set to 800 x 600 or 1280 x 1024 different zoom level will be
required. Also when a tool bar is opened that may hide a row or two.
 
V

Vasant Nanavati

Marvin; unfortunately, you can trap the resize event for the workbook window
but not for the application (Excel) window, which I think is what you want.
There is code that can accomplish what you are asking but without the event
being detected, there is no way to know when to trigger the code. It may be
possible through some complicated API programming but I have not had
occasion to research this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resize Report Window 1
Cant get right screen resolution for new 20" monitor 2
Possible to stop Word windows cascading 1
automatically zooming windows 2
Form Position Option 6
Word resizes when closing other applications 2
Controls auto resizing with scree resolution 0
Hide Controls in Subforms 2

Top