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
|