Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank row after control break | Excel Discussion (Misc queries) | |||
Skipping line on control break | Excel Discussion (Misc queries) | |||
Cannot Control - Break out of VBA | Excel Discussion (Misc queries) | |||
Workbook Open - Prevent CTRL Break | Excel Programming | |||
Control & Break | Excel Programming |