Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » Menu Bar For Relative Reference When Creating Macro

Menu Bar For Relative Reference When Creating Macro

Previous | Next
Latest post Sat, Jun 28 2008 4:31 PM by Tom. 2 replies.

  • Sat, Jun 28 2008 10:21 AM

    • Tom
    • Top 200 Contributor
    • Joined on Sat, Jun 28 2008
    • Posts 2
    • Points 26

    Menu Bar For Relative Reference When Creating Macro

    Reply |Contact

    I mistakenly closed the small menu bar that is available when creating a new macro.  It provided 2 choices - toggle macro on/off and the relative reference option.  How do I restore this menu bar?  Thanks!
    • Post Points: 21

  • Sat, Jun 28 2008 11:28 AM In reply to

    Re: Menu Bar For Relative Reference When Creating Macro

    Reply |Contact |Mark as Answer

    Start recording another macro, then goto Tools>Customise and select the Toolbars tab, then check the Stop Recording checkbox

    And don't close it by hitting the "X" when recording a macro or you will lose it again.

    Regards

    Bob

    • Post Points: 5

  • Sat, Jun 28 2008 4:31 PM In reply to

    • Tom
    • Top 200 Contributor
    • Joined on Sat, Jun 28 2008
    • Posts 2
    • Points 26

    Re: Menu Bar For Relative Reference When Creating Macro

    Reply |Contact |Mark as Answer

    Bob,

    Thanks!!!  I really appreciate you taking the time to solve my problem.

    Tom

     

     

     
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.