excel - VBA Break Command bound to a key -
i'm looking disable break (or pause) key in vba, have come against 2 walls.
- how tell vba function key being pressed
- what on.key {name} interrupt?
my workbook forces users have macros enabled setting every sheet xlveryhidden when workbook closed, , setting them visible when opened (and various other bits centered around logging in areas of workbook), meaning vba has used. however, @ points in "workbook_open" routine, if interrupts program, leaves login access vunerable , not want this.
i want able bind interrupt command key combination desire, know is, leaving break key disabled.
thanks in advance
you can via command application.enablecancelkey = xldisabled
.
this link explains pretty well.
Comments
Post a Comment