LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Workbook Open - Prevent CTRL Break

I have a workbook in which the Open Event contains code which deals
with prompting the user for a password, and then allowing them to
continue using the workbook assuming the correct password is entered.

How can I prevent the user breaking out of the macro with the CTRL
Break keys?

Are there any dangers inherent in this approach apart from the obvious
one of myself as 'owner' of the workbook not being able to break out
of the code for admin purposes?

Although I've written code for prompting for and changing passwords,
does anyone have or can point me to a URL which has code to do this?
I'd like to compare an alternative approach.

TIA

Richard Buttrey
 
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
prevent workbook opening if already open by someone else KevHardy Excel Discussion (Misc queries) 0 March 4th 10 10:02 AM
CTRL-N will NOT open a new workbook in Excel sumatradc Excel Discussion (Misc queries) 2 January 6th 06 07:18 PM
Automatically execute a CTRL-ALT-F9 when I open a workbook Antonio Duarte Excel Discussion (Misc queries) 1 June 15th 05 02:48 PM
Open workbook - prevent macros Charles Excel Programming 0 June 23rd 04 08:46 PM
How to disable the Ctrl+Break ? Krzysztof Klimczak Excel Programming 1 July 31st 03 02:21 PM


All times are GMT +1. The time now is 04:10 AM.

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"