Ctrl+break

[DJ100]

Hi,

I have written a stock management system in EXCEL (will be migrating it to SQL Server eventually) but one of my users keeps using CTRL+BREAK to break in and make changes to the spreadsheet - then these changes aren't logged - the whole reason for making it form based in the first place - is there any way to disable this function.

 

[HaHoBe]

Hi, DJ100,

if you have tested your application more than thoroughly - have a look at EnableCancelKey in the object catalogue / VBA help:

Application.EnableCancelKey = xlDisabled

Ciao,
Holger

 

[DJ100]

Thank you . . . works a treat