Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stop Recording Button (Excel 97)

    The Stop Recording button no longer appears when I click Record a New Macro. I can stop recording by going to the Tools menu, but I want the Stop Recording button because it is the only way I know to record using relative references. Can anyone suggest how to get that button back (I swear it was there this morning), or any other way to record using relative references?
    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Stop Recording Button (Excel 97)

    Frequent problem, see <post#=370358>post 370358</post#>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stop Recording Button (Excel 97)

    You have probably clicked the close button of the 'Stop Recording' toolbar instead of clicking the Stop button. Get it back as follows:
    - Create a new workbook.
    - Select Tools | Macro | Record New Macro.
    - Make sure that you will record the macro in 'This Workbook'.
    - Click OK.
    - Select View | Toolbars | Stop Recording
    - Click the Stop button (not the close button!) of the 'Stop Recording' toolbar.
    - Discard the new workbook; you don't need the macro or the workbook.
    You should now see the 'Stop Recording' toolbar when you record a new macro.

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stop Recording Button (Excel 97)

    Thanks so much. I'm happy to see it is called "a frequent problem" (although it never happen to me since 1997!), so that I'm not totally out of it.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Stop Recording Button (Excel 97)

    If I've done it more than once, it's a frequent problem. <img src=/S/anigrin.gif border=0 alt=anigrin width=19 height=19>
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •