Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default How to disable Ctrl+Break

Hi Shu,

User can press
Ctrl+Break to go into to the VBA editor environment, which
is not supposed to happen.


1) use
Application.EnableCancelKey = xlDisabled
at the beginning of your code to avoid ctrl+break

2) hide your vba modules and protect them with a password
vba-editor, menu extras/properties of vba-project/protection

activate the field and enter a password there. This is _no_ absolute
protection, however, you cannot do more.

regards

arno



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
disable CTRL-pageup & pagedown Boss Excel Discussion (Misc queries) 4 January 8th 08 06:08 PM
Disable CTRL+D??? CMIConnie Excel Discussion (Misc queries) 0 February 9th 06 07:52 PM
Stopping a macro without using Ctrl Break Julian[_2_] Excel Programming 1 October 27th 03 02:39 AM
How to disable the Ctrl+Break ? Krzysztof Klimczak Excel Programming 1 July 31st 03 02:21 PM
disable ctrl+s susie Excel Programming 1 July 24th 03 08:02 PM


All times are GMT +1. The time now is 03:53 PM.

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

About Us

"It's about Microsoft Excel"