Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK

M

Marcello do Guzman

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: (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autorun macro does not autorun... 5
Deactivate / Reactivate the Paste Function in excel 1
How to DISABLE THE CONTROL BREAK shortcut keys 3
VBA code does not work 7
before_print does not work - f8 key does not do anything 2
workbook_open() sub does not work 2
Right Click Menu not working when sheet is in Page Break Preview m 7
replacing built in keyboard shortcuts with my macros? 2

Top