Can This Be Disabled?

[reuven74190]

Hello Everyone

I am designing a scheduling system for my work using Excel 2000. I
order to make the interface secure, I have already disabled al
toolbars, right-click options, tabs, etc. However, the problem I hav
is that when you double-click on the top bar of excel (the one whic
displays the file name, the minimize, restore, and close buttons), i
will restore down the size of the window. I need to have this windo
always stay maximized. I have already disabled the three buttons o
that bar (minimize, restore, and close), but I can't find a way t
disable the double-click on that bar restoring it down. I'm not sure i
an Application-Level event can be used to disable this feature. Doe
anyone have any suggestions/solutions to this situation?

Thanks
Jaso

 

[Steve Garman]

I don't know of a way of doing this.

However, you could periodically check the windowstate and re maximize
the window if it needs it.

With Application
If .WindowState <> xlMaximized Then
.WindowState = xlMaximized
End If
End With

 

[NickHK]

reuven,
You can try removing the Excel's control box in the top left hand corner. I
saw something recently about this, involving using SetWindowLong, as far as
I remember.

NickHK