How Do I Run A Macro When Excel Is Resized?
 

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

How Do I Run A Macro When Excel Is Resized?
 

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



--
Regards
Frank Kabel
Frankfurt, Germany

"Tim Hubbard" schrieb im Newsbeitrag
om...
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

How Do I Run A Macro When Excel Is Resized?
 

"Frank Kabel" wrote in message
...
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 *


"Tim Hubbard" schrieb im Newsbeitrag
om...
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

How Do I Run A Macro When Excel Is Resized?
 

"Rob Bovey" schrieb im Newsbeitrag
...
"Frank Kabel" wrote in message
...
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.

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

Frank