Prevent Window Resize Or Moving Revisited
It's not quite what you're looking for, but there's a KB article describing
how to create application level event handlers.
XL97: How to Create Application Level Event Handlers
Article ID: Q158244
The given example is the WindowResize event, which is on the same lines as
Chemistry & Chemical Engineering Labs.
SRI International, Menlo Park, CA
>Let me restate what I am trying to accomplish. I need to prevent the
>Excel window from being resized when the Excel title bar is
>double clicked. Clicking Tools, Protection, Protect Workbook and
>checking Structures and Windows does not do this.
>One suggestion that looked like it might work was the following code:
> ActiveWindow.EnableResize = False
>Unfortunately, this does not accomplish what I am trying to do.
>I think this might require a call to the windows API. If anyone is
>familiar enough with the Windows API, I would greatly appreciate any
>suggestions on code that might accomplish the disabling of window resize
>when the Excel title bar is double clicked. Thanks in advance.
>Hector J. Lara