|
Subject:
|
Is there an Event for resizing the main XL window?
|
|
Posted By:
|
labdad
|
Post Date:
|
12/15/2005 3:12:28 PM
|
I am building an application that has forms that overlay the the areas above and below the workbook. If a user resizes the main XL window (smaller), my forms will appear to hang out over the desktop. Ideally, I would like to use an event (like the workbook resize event) to deal with this. Is there such an event? Alternatively, is there a way to prevent the user from being able to resize the XL window?
|
|
Reply By:
|
mjppaba
|
Reply Date:
|
12/21/2005 10:22:11 AM
|
Is this what you were after?
Sub Change_Excel_Size()
Application.WindowState = xlNormal
With Application
.Left = 222.25
.Top = 289.75
.Width = 127.5
.Height = 30.75
End With
End Sub
cheers
Matt
|
|
Reply By:
|
labdad
|
Reply Date:
|
1/6/2006 6:23:12 PM
|
Matt, thanks for taking the time to reply.
Your solution tells how to re-size, but my burning need is to have my code know WHEN to resize, or as an alternative, how to prevent the user from re-sizing the XL app window.
|
