Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Macros in Excel 2003
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
exce+training - Macros in Excel 2003
Resolved · Low Priority · Version Standard
Reply Fri 30 Nov 2007, 13:30Delegate Carolyn said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Sun 2 Dec 2007, 10:57Delegate Carolyn said...
RE: Macros in Excel 2003
Many thanks for your help Amanda, that's great cheers
|