Spreadsheet control resizer

How can I get rid of that resizer in the bottom-right of a Spreadsheet control? I looked through all the properties and in the Commands and Options dialog, but I can't find any way to stop the user being able to resize the control during runtime.

Also, this isn't worth starting a topic over but is there a known issue with a DateTimePicker control whereby the control moves itself to (0, 0) after setting Enabled to false, then back to true? I'll elaborate on this if need be.

Thanks.

:(

Is there not even a way to disable it with Windows API code? I can work around this problem, but I'd rather not create a messy hack until I'm sure I've got no other choice.

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.

Code:

---

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.

Well, here is the real answer for the INTERIOR window ...

Application.ActiveWindow.EnableResize = False

I couldn't find the equivalent for the outer Excel Window. Any help here?