+ Reply to Thread
Results 1 to 4 of 4

assign keyboard shortcut

  1. #1
    Registered User
    Join Date
    05-26-2007
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    51

    assign keyboard shortcut

    Hello
    Is it possible in excel to assign your own keyboard short cut.
    for example i want a key board short cut for . tools, document protection,the shortcut key may be ctrl+1
    thanks

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    There may be a simpler way I don't know of, but I've done this by recording a macro of me accessing the deeply nested menu option, then stopped the recording before I'd done anything with the tool's window.

    When you first choose to record the macro, you can select your Ctrl+(whatever) key combination, AND you ca choose to store the macro in the workbook you currently have open, or create a Personal Macro Workbook.

    The Personal Macro Workbook allows these special macros to be accessible every time you open Excel.

    EDIT: I wasn't able to get a macro to popup the protection window, only worked when I actually saved some protection settings. Sorry, but maybe you want to do that?
    Last edited by JBeaucaire; 11-30-2008 at 05:29 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    perhaps here
    http://www.ozgrid.com/VBA/excel-work...rotect-all.htm

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You could do it like this:
    Please Login or Register  to view this content.
    Run ToStart, which reassigns (sort of) Ctrl+1 from format cells. Before you quit, run ToQuit.

    I can't recommend this particularly, but don't know of a better way to do it.
    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)

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