Forum home » Delegate support and help forum » Microsoft Word Training and help » Macros

Macros

ResolvedVersion 2003

Wed 27 May 2009, 16:57 Delegate Rosie said...

Rosie has attended:
Word Intermediate course

Macros

Can I create a macros in excel like I can create one in word?

Wed 27 May 2009, 17:11 Trainer Amanda said...

RE: Macros

Hello Rosie

Thank you for your question and welcome to the forum.

Yes, you are able to create macros using the macro recorder in Excel like you can in Word.

The only slight difference to be aware of is that if you are recording a macro that has something to do with using a formula, then there is a button that controls whether the macro will use relative references or not.

You may notice this additional button on the Record Macro toolbar that appears on your screen when recording, next to the Stop Recording button.

Kind regards
Amanda

Wed 3 Jun 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Find out all Word's shortcut keys

Want to learn more Word shortcut keys?

Here's how to you can find more shortcut key combinations:

1. Look up shortcuts in Help - this should bring up a link to the Keyboard Shortcuts topic.

2. Word has a built-in macro that you can run which will produce a list of all Word's shortcut keys that you can then print.

To access the macro, go to Tools - Macro - Macros. Use the dropdown arrow next to Macros in: to select Word commands.

Scroll down the list under Macro names and select ListCommands, then click Run.

Click OK. A document listing shortcut keys should be generated for you, which you can print for future reference.

View all Word hints and tips

Macros

Macros

RE: Macros

Word articles

Word tip:

Find out all Word's shortcut keys