How Do I Run A Macro When Excel Is Resized?

[Tim Hubbard]

I have an excel application which I have stripped down (removed
scrollbars, etc). To keep the whole page in frame, I would like to
have it rezoom when the window is resized. Can anyone provide me a
code sample on how to do this?

Thanks,
Tim

 

[Frank Kabel]

Hi
try using the workbook event:
Private Sub Workbook_WindowResize(ByVal Wn As Window)

 

[Rob Bovey]

Hi
try using the workbook event:
Private Sub Workbook_WindowResize(ByVal Wn As Window)

Hi Frank,

That only fires when a workbook window *inside* the Excel application
window is resized. There is no event I know of that will fire when the Excel
application window itself is resized, which I believe is what the OP is
looking for.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Frank Kabel]

Hi Frank,

That only fires when a workbook window *inside* the Excel application
window is resized. There is no event I know of that will fire when the Excel
application window itself is resized, which I believe is what the OP is
looking for.

Hi Rob
you're probably right. Misread the OP's posting

Frank