excel - VBA Break Command bound to a key -


i'm looking disable break (or pause) key in vba, have come against 2 walls.

  1. how tell vba function key being pressed
  2. 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

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -