Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel save as pdf multiple sheets - graph resized | Excel Discussion (Misc queries) | |||
Spreadsheet resized when printed | Excel Discussion (Misc queries) | |||
comments resized themselves | Excel Discussion (Misc queries) | |||
How to protect cells from getting deleted or resized? | Excel Worksheet Functions | |||
Protect Objects so they cannot be resized | Charts and Charting in Excel |