A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Basic macros query - where are they assigned to?



 
 
Thread Tools Display Modes
  #1  
Old January 15th, 2005, 03:35 AM
Bert Coules
external usenet poster
 
Posts: n/a
Default 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  
Old January 15th, 2005, 03:56 AM
Greg Maxey
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 04:08 AM
Bert Coules
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 04:31 AM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 04:37 AM
Greg Maxey
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 02:55 PM
Bert Coules
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 05:53 PM
Greg Maxey
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 06:05 PM
Daiya Mitchell
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 08:16 PM
Doug Robbins
external usenet poster
 
Posts: n/a
Default

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  
Old January 15th, 2005, 09:43 PM
Bert Coules
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
AVG Function in a Query JohnL Running & Setting Up Queries 5 December 18th, 2004 06: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
Print 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


All times are GMT +1. The time now is 01:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.