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

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
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.
 
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.
 
Back
Top