View Single Post
  #4   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?


"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