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