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" <(E-Mail Removed)> wrote in message
news:4DAC757D-1FAA-4D64-B187-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:4DAC757D-1FAA-4D64-B187-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:4DAC757D-1FAA-4D64-B187-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:A91493EC-E411-427A-8957-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:4DAC757D-1FAA-4D64-B187-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:4DAC757D-1FAA-4D64-B187-(E-Mail Removed)...
>> how (if posible) can i disable the red cross at the top right hand coner
>> to
>> prevent ppl closing the workbook that way?
>>
>
>