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

Are you talking about closing the workbook or closing the Excel application?
__________________________________________________ _______________________

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

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



"Vasant Nanavati" wrote:

Are you talking about closing the workbook or closing the Excel application?
__________________________________________________ _______________________

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

See
http://groups.google.ca/group/micros...d264901943f109

or use Google Group search for: red x disable group:*excel*
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

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
__________________________________________________ ________________________



"pswanie" wrote in message
...
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



"Vasant Nanavati" wrote:

Are you talking about closing the workbook or closing the Excel
application?
__________________________________________________ _______________________

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

I don't know that I would mess with system menus except as a last resort,
unless I was constructing a dictator app.
__________________________________________________ _______________________
"Bernard Liengme" wrote in message
...
See
http://groups.google.ca/group/micros...d264901943f109

or use Google Group search for: red x disable group:*excel*
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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