Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF To Calculate Work hours between two dates Problem with code jlclyde Excel Discussion (Misc queries) 4 August 13th 07 06:47 PM
How to DISABLE THE CONTROL BREAK shortcut keys Marcello do Guzman Excel Programming 3 January 9th 04 01:48 PM
VB code for disabling DJ Excel Programming 2 November 10th 03 09:01 AM
Disabling Sheet Code Stuart[_8_] Excel Programming 2 October 2nd 03 12:34 AM
Disabling Shortcut Hot Keys Dan Gesshel Excel Programming 1 September 15th 03 09:12 PM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"