+ Reply to Thread
Results 1 to 3 of 3

How do I block all short cut keys or Alt-F4 using vba Excel User Form?

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    3

    Post How do I block all short cut keys or Alt-F4 using vba Excel User Form?

    Ok I have created a secure login in excel. so I have used a User form- for the user interface and two modules - One for opening the user form when excel loads, the other to remove the close button using Microsoft api. These two modules are successful in terms of security for the client. However, I have encountered a way of bypassing the user form with the simple ALT + F4 Key, and this risk I cannot allow. So, how would I remove/disable the ALT+F4 KEY or even better remove/disable all short cut keys temporally while the user is logging in.

    In VBA Programming language NOT Macro please.

    Thanks

    Milan

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: How do I block all short cut keys or Alt-F4 using vba Excel User Form?

    This will block Alt+f4 (as well as X - easier than API!)
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    11-13-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: How do I block all short cut keys or Alt-F4 using vba Excel User Form?

    F*** HELL!!! YOUR SUCH AN EXPERT!!!! Wish i was you!!

    Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Short Cut Keys for Excel.
    By koa786 in forum Excel General
    Replies: 10
    Last Post: 10-24-2008, 03:17 PM
  2. English formulas and short cut keys on danish Excel
    By Kjaer in forum Excel General
    Replies: 2
    Last Post: 03-11-2008, 07:56 PM
  3. Excel Short Cut Keys
    By Reyan123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2006, 07:39 AM
  4. Assigning Short-Cut Keys
    By Marco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2006, 05:45 PM
  5. [SOLVED] Accelerator keys in user form not working
    By Jennifer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2005, 08:06 AM

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