Results 1 to 9 of 9
  1. #1
    KTYorke
    Guest

    What's that keystroke? (VBA/ Word 97)

    This has got to be a basic question and I have a feeling I'll be smacking my head once one of you responds... I didn't find anything in a search either...

    I recorded a macro to shade cells in a table... Works great, but after a few days I've gone back into the document and forgot what keystroke combination I had assigned the macro... Where do I look to figure that out? Thanks
    have fun

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What's that keystroke? (VBA/ Word 97)

    and if anyone knows the excel version of the answer, I'd love to know it.

    Brooke

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What's that keystroke? (VBA/ Word 97)

    Don't know the Word answer, but for Excel 97, whenever I have recorded a maco and assigned a keyboard shortcut, the shortcut shows up in the comments section of the code.
    Attached Images Attached Images

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What's that keystroke? (VBA/ Word 97)

    In Word, click on the Tools menu and select Customize. You'll see a keyboard button at the bottom of the Customize dialog. If you click that, you'll get a Customize Keyboard dialog. There, you can select Macros from the Categories list and when you highlight the macro in question, you'll see the shortcut you assigned in the Current Keys field.
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What's that keystroke? (VBA/ Word 97)

    In Excel, if you select Tools-->Macro-->Macros you'll see the existing macros for that workbook. If you select a macro and then click on Options, you'll see (and be able to change) the assigned shortcut.
    Charlotte

  6. #6
    KTYorke
    Guest

    Re: What's that keystroke? (VBA/ Word 97)

    <img src=/S/joy.gif border=0 alt=joy width=23 height=23> You Rock Charlotte!!
    have fun

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What's that keystroke? (VBA/ Word 97)

    Nah, that's just my head you heard rattling. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  8. #8
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What's that keystroke? (VBA/ Word 97)

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15>. Thankyou. There wouldn't be a way of accessing this through VBA that you know of, would there? Something like Application.UserDefinedShortcuts or similar? Not that it's happened recently but I have come across some very ugly macro's assigned to combinations like [ctrl]+C and a way of getting a headsup would be quite nice.

    Brooke

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What's that keystroke? (VBA/ Word 97)

    I don't know. I rarely work in Word or Excel and the only time I assign keystrokes to macros is in Access and then only for my own use. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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