I don't know if there is a way to disable the double-click via the API. If
your concern is that you maximized Excel and users can restore it, you might
try maxing the restore position by including code like this:
Sub MaxRestorePos()
Dim MaxW As Double
Dim MaxH As Double
With Application
.ScreenUpdating = False
.WindowState = xlMaximized
MaxW = .Width
MaxH = .Height
.WindowState = xlNormal
.Left = 0
.Top = 0
.Width = MaxW
.Height = MaxH
End With
End Sub
--
Jim
"Daveh" wrote in message
...
|I have used the code at
|
|
http://support.microsoft.com/default...b;en-us;814562
|
| " How to programmatically delete the Window Control menu commands in Excel
| 2002 "
|
| which appears to work , but double clicking the menu bar still allows the
| restore command to work. I am using Excel 2003 in Windows XP.
|
| Any thoughts ?