Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open - Prevent CTRL Break
Take a look at:
Application.EnableCancelKey in VBA's help. (if your code runs before the quickest of users!) Maybe you could have a dummy workbook set this, then open your workbook. If they cntl-break, then only your dummy workbook is opened. Richard Buttrey wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent workbook opening if already open by someone else | Excel Discussion (Misc queries) | |||
CTRL-N will NOT open a new workbook in Excel | Excel Discussion (Misc queries) | |||
Automatically execute a CTRL-ALT-F9 when I open a workbook | Excel Discussion (Misc queries) | |||
Open workbook - prevent macros | Excel Programming | |||
How to disable the Ctrl+Break ? | Excel Programming |