98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Macros in Excel 2003
exce+training - Macros in Excel 2003
Resolved · Low Priority · Version 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
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. |
Excel tip:Shortcut for deleting all comments in a spreadsheetIf you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by: |