Word macros - what keystroke combo, I forgot...

[davegmail]

Word macros - what keystroke combo, I forgot what my [delete word] macro was (such as shift+ctr+d).

How do I get a list of all macros with their respective keystroke combinations are?

I don't understand the visual basic editor. It seems very confusing.

Thanks, Dave

 

[jfhewitt]

Open Word, click on help Icon (little yellow question mark), type "hot keys" and follow instructions.

 

[xlhelp]

Under File, Print, Print What drop-down, select Key Assignments

Me transmitte sursum, Caledoni!

 

[fumei]

Or,

Tools > Customize

Select Macros (in Categories), and click the Keyboard button.

Select Macros in new dialog (in Categories again...why...who knows).

Every available macro, in all available templates, is accessible to both see, and set, keyboard shortcuts.

Gerry
My paintings and sculpture

 

[tf1]

Or use File, Print and from the Print What box select Key Assignments.


Regards: tf1

 

[fumei]

tf1...uh...you're a little late on that one. <grin>

Gerry
My paintings and sculpture

 

[tf1]

Oh! So I was. I didn't read that bit because all the funny colours made me think it was just a ghastly signature block - which I make a point of never reading!

Terry

Regards: tf1

 

[fumei]

darn those colours darn them

Gerry
My paintings and sculpture

 

[davegmail]

Wow, guys! I'll check these all out. By the way, can I send a copy of my Macros or a subset to a friend?

I create a lot of meeting transcripts with up to 10 speakers. For example:

CTR+Alt+J = Joe: (with yellow highlight)
CTR+Alt+S = Steve: (with yellow highlight), etc.

This saves ton's of time & allows quick review of
who said what.

Thanks to all. Will check this tomorrow.

Dave

 

[fumei]

Hi Dave,

I am not getting your question, rather your example.

Can you send copies of macros? Well, yes, in a way. You can copy your macros to another file and send that file.

But could clarify

I create a lot of meeting transcripts with up to 10 speakers. For example:

CTR+Alt+J = Joe: (with yellow highlight)
CTR+Alt+S = Steve: (with yellow highlight), etc.

This saves ton's of time & allows quick review of
who said what.

Huh? Please describe exactly what you are thinking you want to happen.

Gerry
My paintings and sculpture

 

[davegmail]

fumei (thanks for reply)

I'd like to send a copy of my macros to my buddies for testing and review. They may find them useful. They might also modify them and send them back.

In the examples, I create paragraphs of their speech.

Steve: We need to have a board meeting. Rick: Ok, the time is 7:00 PM. Bill: Can we start with old business? ......etc.

I use yellow highlight in MS Word with each [person:] to show who said things.

Does that help? Dave

 

[fumei]

No...it does not help ar all.

Yeah...OK, so you highlight certain chunks of text. That's nice. What has that got to do with sending copies of macros????????

Back to sending macros. Again, make a document and use the Organizer to copy macros from one file to the other. This is not difficult.

But what has that to do with highlighting text????

Gerry
My paintings and sculpture

 

[davegmail]

fumei / Gerry - you just don't get it.

Have you ever done a transcript of a meeting?

I need to show who said what.

Bob: I need help. Jim: Ok, send me a copy of the file. Bob: Thanks. Jim: OK.

Each speaker gets yellow highlight - get it?
Then in a 20 page document, I can quickly see who said stuff. The macros I use create Bob etc. with highlight.

-----
Either that or forget I even said this.

"What has that got to do with sending copies of macros????????"

It has nothing to do with sending macros. That is a different subject (duh?).
--------

"Organizer to copy macros from one file"
Thank you for the advice on sending macros. I'll try this.

Dave

 

[fumei]

What, do you think I'm stupid? YES, I understand that transcripts can get highlights. And your point is? if this is a different subject...well hows about telling us what the subject IS. Here is EXACTLY what you wrote.

By the way, can I send a copy of my Macros or a subset to a friend?

I create a lot of meeting transcripts with up to 10 speakers. For example:

CTR+Alt+J = Joe: (with yellow highlight)
CTR+Alt+S = Steve: (with yellow highlight), etc.

This saves ton's of time & allows quick review of
who said what.

I answered...can you send copies of macros . Yes, you can. I told you how. Then I ask...what are you asking re: the highlights.

I still don't know what you are asking re: the highlights. here is another quote.

The macros I use create Bob etc. with highlight.

That means you already HAVE the macros. So...what the heck are you asking???? You mention highlighting. Yes, I know what highlighting is. And yes, I know what highlighting can be used for.


But...why are you mentioning highlighting. You still have not answered. All I was trying to do was find out why you mention the highlighting.

Here is another quote.

I'd like to send a copy of my macros to my buddies for testing and review. They may find them useful. They might also modify them and send them back.

In the examples, I create paragraphs of their speech.

Steve: We need to have a board meeting. Rick: Ok, the time is 7:00 PM. Bill: Can we start with old business? ......etc.

I use yellow highlight in MS Word with each [person:] to show who said things.

Please read that. Would not a reasonable person conclude there may be SOME connection between your paragraphs? Hmmmmm?? You ask about sending macros...and...hmmm...highlighting.


So please, if there is some connection, tell me. If there is something about those macros that do the highlighting, tell me. I know what highlighting is, and for...WHAT is the point? WHY are you mentioning it? If there is something about the macros you are asking...then ask it.

Otherwise, if the question is - ONLY - can I send macros?...then...who cares what the macros DO? Whether they do highlights, or reformat paragraphs, or merge documents, or do sophisticated numbering, or search multiple files for specific text and collate them into a new document with a table of references from which document they came from, or looping through a folder of files looking in them for specific text and...hmmmm... highlighting them, or.....

If the question was regarding sending macros, then what the macros do is irrelevant. I was trying to determine if it was relevant.

A simple: "Oh, I just mentioned the macros actions, no, sorry, that is not relevant." Then gosh...that would have quite clearly answered my questions regarding it.

If you are bringing in a different subject, that is perfectly fine. Say what it is.

Thanks.



Gerry
My paintings and sculpture

 

[davegmail]

Gary - no need to get so anal retentive. Sheesh! I was using the highlighting macro as an example. Hello!!

PS - is there a way to get a list of Key Assignments into a file such as "Key Assignments.txt" It might be useful to have different sets of macros for different uses.

====
This was more helpful, I did not learn this above, where are macros stored:

http://www.findarticles.com/p/articles/mi_zdpcm/is_200211/ai_ziff32722

"Word macros are stored in templates. You probably store yours in Normal.dot , the default template Word uses for all documents. A corrupted template can cause Word to misbehave—or stop functioning entirely—so it's a good idea to make a backup copy of your template before you do any substantial macro editing.

To save templates safely, first close Word if it is open and then use File | Save As to create a copy of Normal.dot with another filename. We copied Normal.dot to Normal.001 the first time we edited it, then Normal.002, and so forth. Using the date in the filename can also be useful. Such naming strategies provide a trail of fallback versions if they are needed."

 

[fumei]

Gary - no need to get so anal retentive. Sheesh! I was using the highlighting macro as an example. Hello!!

Well, Hello!!! back. Uh....that was my point. You did not say it was an example, and I tried to find out if it was. Sheeesh. And, BTW, if I may ask...although this is similar to previous posts, what was the point of describing what the macro DOES, when the the question was not about that, but about if you can send one. So I was trying to find out why you were describing it, what was the point of describing...when the description had nothing, at all, to do with what you were asking.

Sheeesh again.

It might be useful to have different sets of macros for different uses.

Yes, it is. That is why it is good to NOT put macros in normal.dot. You can keep macro "sets" in their own file, if you want.

This was more helpful, I did not learn this above, where are macros stored:

This is a true, although I did write:

Every available macro, in all available templates, is accessible to both see, and set, keyboard shortcuts.

Yes, perhaps it would have been better to state "Every available macro, in all available templates (which is where macros are stored)". I will remember that next time.

Gerry
My paintings and sculpture

 

[davegmail]

Sorry for all the misunderstandings. That is the trouble with text vs speech. Nuances can get in the way of communication.

I did learn something very valuable about not putting macros into the normal.dot. Word and Excel for that matter could use a better storage scheme for different uses, users, groups for that matter. Maybe it exists, I am not aware of it.

Example? Dave_Macro.dot, Tom_Macro.dot, etc. for each user for example. How do your enable each user's macros?

New Topic
I used to use macros extensively for data manipulation, parsing data, and showing shortcuts to users. Now I use them to speed up my work.

I even have a HYPERLINKS creation macro for Excel. For a file list, with captured info on size, time & date, etc - it creates the hyperlinks in a flash.

This then permits me to rapidly find, sort, retrieve *.docs, *.xls, *.pdf etc. files - I can sort by topic, date, size - for example.

Best regards, Dave

 

[fumei]

Example? Dave_Macro.dot, Tom_Macro.dot, etc. for each user for example. How do your enable each user's macros?

It is not really a question of "enabling".

You use global templates. Globals can be set up to load the macros (that is, make them available) upon Word starting.

To load automatically, you can put them in two locations.

C:\Documents and Settings\username\Application Data\Microsoft\Word\Startup

This will load the global template upon that user starting Word. That user will get the macros.

C:\Program Files\Microsoft Office\Office10\Startup

This will load the global upon an Office application starting up. All users on that machine will get the macros.

Globals can also be stored in ANY folder.

C:\Corporate\Global_Templates is perfectly fine. A global may be loaded from there with Tools > Templates and Addins. Browse for the template, and load it. This is also where you can load and unload globals - they do not have to be loaded on startup. In fact you can have Normal.dot - say if it was a corporate normal.dot, check the current user, and load that user's global.

Other document template files (which of course can contain macros) can also be used to load global templates.

So, actually, Word has a variety of methods for storage and retrieval of macros. What set up is used depends on your requirements.

Gerry
My paintings and sculpture