Spreadsheet control resizer

[Webtest]

I hope somebody (smart?) jumps on this ... maybe DKenny or Robdog ...

This may be where you do it ... it is one of the Workbook events in the "ThisWorkbook" module ... but I'm not sure how to intercept and block the event.

Private Sub Workbook_WindowResize(ByVal Wn As Window)
    'SOMETHING GOES HERE TO EAT THE EVENT!
End Sub

EDITED: Hmmmm ... I spoke too soon. This has 2 problems ...

1) It only affects the SHEET window inside the Excel Window. It has nothing to do with the Excel window.

2) This event is fired AFTER the sheet is resized! To use it you would have to save the size of the window when it is opened, then after it is resized, restore it back to the saved value. Yuk!

I hope somebody is good with API calls! (hint ... hint) Search this Forum for "API" ... I think there are some good threads on APIs and some links to good sites as well.