How Do I Run A Macro When Excel Is Resized?

T

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
 
F

Frank Kabel

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

Rob Bovey

Frank Kabel said:
Hi
try using the workbook event:
Private Sub Workbook_WindowResize(ByVal Wn As Window)
Click to expand...

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 *
 
F

Frank Kabel

Rob Bovey said:
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.
Click to expand...
Hi Rob
you're probably right. Misread the OP's posting :)

Frank
 
Top