Prevent control & break
 

I interested to know if there is a known way to prevent a user effectively
causing a workbook_open event to halt by disabling the control/break key
strokes.

Ideally I would to include such code, if it exists as the frist line of
the workbook_open code.

Thanks
N10





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

Prevent control & break
 

Look in Excel VBA help at the EnableCancelKey method.

--
Regards,
Tom Ogilvy
"N10" wrote in message
...
I interested to know if there is a known way to prevent a user effectively
causing a workbook_open event to halt by disabling the control/break key
strokes.

Ideally I would to include such code, if it exists as the frist line of
the workbook_open code.

Thanks
N10





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

Prevent control & break
 

Thanks Tom

Just the ticket


Best
N10

"Tom Ogilvy" wrote in message
...
Look in Excel VBA help at the EnableCancelKey method.

--
Regards,
Tom Ogilvy
"N10" wrote in message
...
I interested to know if there is a known way to prevent a user
effectively
causing a workbook_open event to halt by disabling the control/break key
strokes.

Ideally I would to include such code, if it exists as the frist line of
the workbook_open code.

Thanks
N10





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004