disable the red "x" @ top right coner
 

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

disable the red "x" @ top right coner
 

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?

disable the red "x" @ top right coner
 

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?

disable the red "x" @ top right coner
 

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?

disable the red "x" @ top right coner
 

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?

disable the red "x" @ top right coner
 

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?