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

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.