View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Recording Macro, toggle absolute/relative reference, button disapp

Hi Kayos,

Tools, macro, record a macro
reply to dialog box
View, toolbars, click on stop recording

additional information:
You lost the button by hitting the [x] in upper right corner
and had to use the tools, macro, stop recording in the meantime.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kayos" wrote in message ...
If you want to change between relative and absolute cell reference when
recording a macro, a button should appear for "Stop recording" and "toggle
reference"

However this has only appeared once on both of my computers (Office 2003 on
XP and Office 97 on Windows 98), even after rebooting I cannot persuade this
button to re-appear!

Help please?