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.