+ Reply to Thread
Results 1 to 5 of 5

Disable Certain Keyboard Shortcuts

  1. #1
    Forum Contributor
    Join Date
    04-23-2014
    Location
    United Kingdom
    MS-Off Ver
    Microsoft 365
    Posts
    149

    Disable Certain Keyboard Shortcuts

    I found some great source code from a website (https://www.rondebruin.nl/win/s4/win012.htm) that enables you to disable the user's ability to use keyboard shortcuts. I've used the blocks of code that disable/enable all keyboard shortcuts — not just ones that are listed.

    I'd like to adapt the code so that I can disable all keyboard shortcuts, but still list any exemptions at the bottom. So for example, the following will block all attempted keyboard shortcuts, but how can I allow Ctrl + X, Ctrl + C, Ctrl + V and any others to be exempt?

    Please Login or Register  to view this content.
    Last edited by Statto; 09-20-2017 at 09:00 AM.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Disable Certain Keyboard Shortcuts

    Perhaps this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    04-23-2014
    Location
    United Kingdom
    MS-Off Ver
    Microsoft 365
    Posts
    149
    Quote Originally Posted by xlnitwit View Post
    Perhaps this
    Please Login or Register  to view this content.
    Is there a way of doing it so I can just list the specific keyboard shortcut keys I want to exempt from being disabled? Kind of like that website’s example at the top but the opposite.

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Disable Certain Keyboard Shortcuts

    I would suggest you simply disable everything and then use the array method to re-enable just the ones you want.

  5. #5
    Forum Contributor
    Join Date
    04-23-2014
    Location
    United Kingdom
    MS-Off Ver
    Microsoft 365
    Posts
    149

    Re: Disable Certain Keyboard Shortcuts

    Quote Originally Posted by xlnitwit View Post
    I would suggest you simply disable everything and then use the array method to re-enable just the ones you want.
    You've said exactly what I'm trying to achieve. Have you got a code solution for that?

+ 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. keyboard shortcuts
    By bobhope24 in forum Excel General
    Replies: 1
    Last Post: 08-13-2008, 10:51 AM
  2. Replies: 1
    Last Post: 02-08-2007, 10:57 AM
  3. Keyboard shortcuts
    By Greka in forum Excel General
    Replies: 5
    Last Post: 07-18-2006, 11:45 AM
  4. keyboard shortcuts
    By Villain in forum Excel General
    Replies: 3
    Last Post: 05-18-2006, 01:10 PM
  5. [SOLVED] Keyboard Shortcuts
    By Conan Kelly in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2006, 02:10 PM
  6. [SOLVED] Disable keyboard shortcuts in formula edit mode?
    By Dirk Van de moortel in forum Excel General
    Replies: 1
    Last Post: 12-16-2005, 11:10 AM
  7. Disable keyboard shortcuts in formula edit mode?
    By Dirk Van de moortel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2005, 11:10 AM

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