+ Reply to Thread
Results 1 to 2 of 2

Unbreakable Procedure--Breaking the Escape Key

  1. #1
    Registered User
    Join Date
    11-27-2008
    Location
    USA
    Posts
    1

    Unbreakable Procedure--Breaking the Escape Key

    First question in a series of posts in fool-proofing a workbook:

    Right now I'm trying to create a "login" through excel. I've gotten as far as making a form with username and two passwords, and relatively short code so that it's hopefully executable before a user can do anything.

    Nonetheless, the ESCAPE key seems determined to enable my procedure's downfall, despite my attempts to stop it from doing so.

    Here's the code I've wrought so far:

    Please Login or Register  to view this content.
    Note the .EnableCancelKey is disabled and on hitting ESCAPE nothing should occur, yet especially when the procedure is working on the Workbooks.Open statement, the ESCAPE key fails it and the common error/debug message occurs. I have not encountered this problem anywhere else in the code (like I said, it's short enough that there's no time for someone to hit escape), but I can't help but feel that this error would occur similarly otherwise.

    Any suggestions on making the Unbreakable Procedure would be greatly appreciated!
    Last edited by DMProgrammer100; 11-28-2008 at 12:06 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1