Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have used the the following VBE code in the 'This Workbook' module
'This disables the ALT+F8, ALT+F11 and CONTROL+BREAK shortcut keys Private Sub Workbook_Open() Application.OnKey "%{F11}", "" Application.OnKey "%{F8}", "" Application.OnKey "^{BREAK}", "" End Sub 'This enables the above shortcut keys Private Sub App_WorkbookBeforeClose(ByVal Wb As Workbook, _ Cancel As Boolean) TestEnableOnKey End Sub However, the CONTROL + BREAK shortcut function does NOT work. I am still get the box that allows you to RUN, DEBUG or CANCEL. Is there anyway to get this to work? Need the VBE code and where exactly it should be placed. Thanks in advance, Marcello email: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UDF To Calculate Work hours between two dates Problem with code | Excel Discussion (Misc queries) | |||
How to DISABLE THE CONTROL BREAK shortcut keys | Excel Programming | |||
VB code for disabling | Excel Programming | |||
Disabling Sheet Code | Excel Programming | |||
Disabling Shortcut Hot Keys | Excel Programming |