Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home

"Use Relative References" in Excel 2000

Posted by Taylor Sutherland on February 19, 2001 7:52 PM
This may seem silly, but I cannot find the "use relative
references" menu option in Excel 2000 for VB macros.

The help said it was under Tools/ Record Macro/ Use Relative
References, but "there ain't no such beastie" that I can
find.

Any help would be appreciated.


Check out our Excel VBA Resources

Re: "Use Relative References" in Excel 2000

Posted by Dave Hawley on February 19, 2001 8:37 PM


Hi Taylor

"They" lied! The relative button is actually on the "Stop Recording" button. This should show as a floating toolbar when you start recording. If it doesn't then you can stop recording by going to Tools>macro>Stop Recording. But this will only be there if you are recording.

To ensure it does show when recording go to View>Toolbars>Customize and select "Stop Recording" on the "Toolbars" page. Click Close, then click the X on the "Stop Recording" Toolbar. The relative reference button is to the right of the Stop button.


Now the "Beastie" should show!

Dave
OzGrid Business Applications


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.