disable the red "x" @ top right coner

[pswanie]

how (if posible) can i disable the red cross at the top right hand coner to
prevent ppl closing the workbook that way?

 

[Vasant Nanavati]

Are you talking about closing the workbook or closing the Excel application?
_________________________________________________________________________

 

[pswanie]

i want to prevent ppl closing the workbook with the "X"

i got a button with a macro that saves, print and quit the workbook.

thanx

 

[Bernard Liengme]

See
http://groups.google.ca/group/micro...l+red+x+disable&rnum=1&hl=en#5bd264901943f109

or use Google Group search for: red x disable group:*excel*

 

[Vasant Nanavati]

There are two Xs, one for the workbook window and one for the application
window.

In any event:

In the ThisWorkbook module:

Public fMacro As Boolean

Private Sub Workbook_BeforeClose()
If Not fMacro Then Cancel = True
End Sub

In your macro which closes the workbook:

'Your code except for the close
ThisWorkbook.fMacro = True
'Code to close
__________________________________________________________________________

 

[Vasant Nanavati]

I don't know that I would mess with system menus except as a last resort,
unless I was constructing a dictator app.
_________________________________________________________________________