+ Reply to Thread
Results 1 to 3 of 3

How to disable CTRL+S shortcut

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Question How to disable CTRL+S shortcut

    Please somebody tell me how to disable CTRL+S shortcut using VBA code in an excel workbook.

    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,951

    Re: How to disable CTRL+S shortcut

    look at this thread

    http://www.mrexcel.com/forum/excel-q...-cut-keys.html

    I would do this in the On Open Event and restore them on the On Close Event so that it works on the particular workbook only. Otherwise, it will disable all machines that open the file and that is not very nice.
    Last edited by alansidman; 09-30-2013 at 07:21 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

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

    Re: How to disable CTRL+S shortcut

    Why not just make the workbook read-only?
    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)

Similar Threads

  1. how to disable ctrl c and ctrl v
    By slmi1313 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2011, 03:04 PM
  2. ctrl + ' shortcut not working
    By rob205 in forum Excel General
    Replies: 2
    Last Post: 08-17-2011, 02:04 PM
  3. Excel 2007 : Ctrl+Alt+F3 shortcut not working
    By huxley76 in forum Excel General
    Replies: 0
    Last Post: 11-10-2010, 12:09 PM
  4. CTRL+F - Shortcut key
    By excelhlp in forum Excel General
    Replies: 1
    Last Post: 08-09-2010, 11:49 PM
  5. using Ctrl+M as shortcut
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-06-2008, 10:01 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