View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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