PC Review


Reply
Thread Tools Rate Thread

Basic macros query - where are they assigned to?

 
 
Bert Coules
Guest
Posts: n/a
 
      15th Jan 2005
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



 
Reply With Quote
 
 
 
 
Greg Maxey
Guest
Posts: n/a
 
      15th Jan 2005
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



 
Reply With Quote
 
Bert Coules
Guest
Posts: n/a
 
      15th Jan 2005
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


 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      15th Jan 2005
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" <(E-Mail Removed)> wrote in message
news:41e88934$0$96065$(E-Mail Removed)...
> 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
>
>


 
Reply With Quote
 
Greg Maxey
Guest
Posts: n/a
 
      15th Jan 2005
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



 
Reply With Quote
 
Bert Coules
Guest
Posts: n/a
 
      15th Jan 2005
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


 
Reply With Quote
 
Greg Maxey
Guest
Posts: n/a
 
      15th Jan 2005
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



 
Reply With Quote
 
Daiya Mitchell
Guest
Posts: n/a
 
      15th Jan 2005
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
>
>


 
Reply With Quote
 
Doug Robbins
Guest
Posts: n/a
 
      15th Jan 2005
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" <(E-Mail Removed)> wrote in message
news:41e920ee$0$32299$(E-Mail Removed)...
> 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
>
>



 
Reply With Quote
 
Bert Coules
Guest
Posts: n/a
 
      15th Jan 2005
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel pivot table with sql query and visual basic macros jpeevey Microsoft Excel Discussion 0 2nd Feb 2010 06:26 PM
UPDATE query - Macros??? Visual Basic??? SQL??? Help! Student Databaser Microsoft Access Queries 2 25th Jun 2008 01:14 AM
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros =?Utf-8?B?SmF5?= Microsoft Excel Programming 1 30th Mar 2007 12:02 AM
What macros are assigned to icons? Terry Pinnell Microsoft Excel Misc 3 28th Feb 2006 07:31 AM
macros assigned to buttons Greegan Microsoft Excel Worksheet Functions 1 2nd Oct 2004 04:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:20 AM.