Q&A

Q1:After I assigned the shortcut key letter “a” to my macro, why couldn't I run it?
A1: Macro shortcut key letters are case sensitive. If you assigned a lowercase letter shortcut key to your macro, make sure the Caps Lock key is turned off when you want to use the lowercase letter to run your macro.
Q2:After recording the wrong actions and commands in my macro and realizing it halfway through the recording process, is it possible to scrap the macro?
A2: Yes. Click the Stop Recording button on the Macro toolbar and choose Tools, Macro, Macros. Then delete the macro and start again.
Q3:Can I stop my macro while it is running?
A3: Sure. Just press the Esc key to stop the macro before it completes its actions.
Q4:Why can't I use my macro in a workbook ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.