If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Basic macros query - where are they assigned to?
I'm sure that the answer to this must be staring me in the face, but I'm
afraid I just can't find it. In the time I've been trying to get to grips with Word 2000, I've created several very basic macros, which I've assigned to particular combinations of keys. In many cases, I've forgotten exactly which keys produce which macros - how do I find out? If I go to Tools/Macro/Macros I get a list which looks like this: Macro 1 Macro 10 Macro 11 Macro 12 and so on. If I highlight any one of these and press Edit, I get a screen which lists the commands for all the macros (separated by horizontal rules) and I can - not unnaturally - edit them. But where in all this does it tell me which keys each macro has been assigned to? Thanks very much! Bert http://www.bertcoules.co.uk |
#2
|
|||
|
|||
Bert,
Right click your menu and press customize then the keyboard button. When the customize keyboard dialog opens, select macros in the categories window. The list of macros will appear in the right window, select one and the shortcut keystroke, if assigned, will be displayed. -- Greg Maxey/Word MVP A Peer in Peer to Peer Support Bert Coules wrote: I'm sure that the answer to this must be staring me in the face, but I'm afraid I just can't find it. In the time I've been trying to get to grips with Word 2000, I've created several very basic macros, which I've assigned to particular combinations of keys. In many cases, I've forgotten exactly which keys produce which macros - how do I find out? If I go to Tools/Macro/Macros I get a list which looks like this: Macro 1 Macro 10 Macro 11 Macro 12 and so on. If I highlight any one of these and press Edit, I get a screen which lists the commands for all the macros (separated by horizontal rules) and I can - not unnaturally - edit them. But where in all this does it tell me which keys each macro has been assigned to? Thanks very much! Bert http://www.bertcoules.co.uk |
#3
|
|||
|
|||
Greg,
Many thanks for the speedy reply. Right click your menu and press customize then the keyboard button... Sorry, but I'm afraid I don't know which menu you're referring to; nothing around the various macro screens seems to produce the result you describe . Would you mind being more specific? Bert http://www.bertcoules.co.uk |
#4
|
|||
|
|||
Open the Tools | Customize dialog. Click the Keyboard button, then select
one of your macros in the list in the Macros category. The shortcut key assignment will be shown under "Current Keys." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Bert Coules" wrote in message ... Greg, Many thanks for the speedy reply. Right click your menu and press customize then the keyboard button... Sorry, but I'm afraid I don't know which menu you're referring to; nothing around the various macro screens seems to produce the result you describe .. Would you mind being more specific? Bert http://www.bertcoules.co.uk |
#5
|
|||
|
|||
Bert,
Just right click any menu or a blank area on menu bar running across the top of the Word screen. "Customize" appears at the bottom of the dropdown. The is a menu button "keyboard" at the bottom of the "Customize" dialog box. You should be well on your way now :-) -- Greg Maxey/Word MVP A Peer in Peer to Peer Support Bert Coules wrote: Greg, Many thanks for the speedy reply. Right click your menu and press customize then the keyboard button... Sorry, but I'm afraid I don't know which menu you're referring to; nothing around the various macro screens seems to produce the result you describe . Would you mind being more specific? Bert http://www.bertcoules.co.uk |
#6
|
|||
|
|||
Many thanks to Greg and Suzanne. I'm still (obviously) getting to grips
with even simple macros; is there a sort of "Macros for Dummies" type guide that I could get hold of? Bert http://www.bertcoules.co.uk |
#7
|
|||
|
|||
LOL,
Macro Dummy. You are in good company. There are dents in the wall by my desk as a result of my frustation gringing through the simplest of macros. Poke around in the VBA beginner and General newsgroups and you will find plenty interesting reading. Good luck. -- Greg Maxey/Word MVP A Peer in Peer to Peer Support Bert Coules wrote: Many thanks to Greg and Suzanne. I'm still (obviously) getting to grips with even simple macros; is there a sort of "Macros for Dummies" type guide that I could get hold of? Bert http://www.bertcoules.co.uk |
#8
|
|||
|
|||
Hi Bert,
If it helps clarify this question--I've always understood that the keyboard assignment is different from the macro. There is nothing hard coded in a macro that sets a shortcut key, generally. Once the macro is created, it is then available via Tools | Customize to have a shortcut key assigned just like any other command. Word offers you a shortcut to this in the macro creation process, but it is still two separate steps and two separate things. E.g., say all your macros and keyboard assignments were saved in the Normal template, and you decided to copy some macros into a different template, the macros will not bring the keyboard assignments with them. I'm very aware of this b/c Word's shortcut has never worked for me. Except it just did, and all it did was open up the Tools | Customize dialog. So your initial instinct--look up the macro to find out the keyboard shortcuts--made sense but did not follow Word's logic--which is that all keyboard shortcuts are assigned/recorded in Tools | Customize, Keyboard. DM On 1/15/05 5:55 AM, "Bert Coules" wrote: Many thanks to Greg and Suzanne. I'm still (obviously) getting to grips with even simple macros; is there a sort of "Macros for Dummies" type guide that I could get hold of? Bert http://www.bertcoules.co.uk |
#9
|
|||
|
|||
See the article "Getting To Grips With VBA Basics In 15 Minutes" at:
http://word.mvps.org/FAQs/MacrosVBA/...csIn15Mins.htm -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Bert Coules" wrote in message ... Many thanks to Greg and Suzanne. I'm still (obviously) getting to grips with even simple macros; is there a sort of "Macros for Dummies" type guide that I could get hold of? Bert http://www.bertcoules.co.uk |
#10
|
|||
|
|||
Doug,
See the article "Getting To Grips With VBA Basics In 15 Minutes" at: http://word.mvps.org/FAQs/MacrosVBA/...csIn15Mins.htm Thanks for that. I had a look at it, but to be frank, it's "aren't I clever" smugness annoyed me rather than helped. Is this automated, choose-from-menus really the only approach? I suppose I do have to get used to the illogical vocabulary of objects and methods and all the rest, but really, isn't it just possible to write a macro as one used to write a simple program in early Basic, with Starts and Ends and Loops and If/Thens and all the rest? Bert http://www.bertcoules.co.uk |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
AVG Function in a Query | JohnL | Running & Setting Up Queries | 5 | December 18th, 2004 05:52 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Basic Query | KiwiBrian | New Users | 1 | October 5th, 2004 09:16 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Using Query Results in Macros | Elliott | Setting Up & Running Reports | 1 | June 5th, 2004 01:35 AM |