Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

exce+training - macros excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Macros in Excel 2003

exce+training - Macros in Excel 2003

ResolvedVersion Standard

Carolyn has attended:
Excel Advanced course

Macros in Excel 2003

Hi There
I have just done my training in Advanced 2007 - which has been very useful but I can't find out where you set the recording of a Macro in 2003 to Relative on the 2003 version (as opposed to Absolute, which I believe is the default setting) - I can't fix this spreadsheet until I can figure out how to set the macro to relative possitioning
Many thanks in advance for your help
Regards

Caz

RE: Macros in Excel 2003

Hi Carolyn

Thank you for your question.

Once you start recording the macro in 2003 (Tools - Macro - Record new macro - OK), there is a small toolbar that appears on your screen that has a Stop button and a Relative Reference button which you can use to set the macro to relative positioning.

If the toolbar doesn't come up on the screen itself, right-click up next to the existing toolbars at the top of the screen and select Stop Recording to turn the toolbar on.

I hope this helps.
Amanda

RE: Macros in Excel 2003

Many thanks for your help Amanda, that's great cheers

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.