1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2007

Discussion in 'Business Applications' started by PincivMa, Apr 16, 2008.

Thread Status:
Not open for further replies.
  1. PincivMa

    PincivMa Thread Starter

    Joined:
    Mar 13, 2004
    Messages:
    378
    Hi there

    Very easy question for you. When you record a macro in Excel 2000, the macro stop button appears. This button allows you to stop recording a macro and also allows you to do relative reference. Is there a similar stop recording button in Excel 2007 that automatically appears when you record a macro?? Or do I have to go to the Developer Command tab in the Code Group and clcik on STOP RECORDING. What about relative referencing when recording a macro in Excel 2007?

    Mario
     
  2. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Give this a try...

    1. Start recording your macro.
    2. On the View menu, point to Toolbars, and then click Stop Recording.

    The Stop Recording toolbar appears.
    3. Perform any additional actions that you want to record in the macro.
    4. On the Stop Recording toolbar, click the Stop Recording button.
    5. On the Tools menu, point to Macro, and then click Macros.
    6. Click the macro name that you recorded, and then click Edit.
    7. Delete the following line from the macro:
    Code:
    Application.CommandBars("Stop Recording").Visible = True
    
    NOTE: This line is recorded when you display the Stop Recording toolbar in step 4 and must be deleted.
     
  3. PincivMa

    PincivMa Thread Starter

    Joined:
    Mar 13, 2004
    Messages:
    378
    Thanks, I'll give it try and see what happens.

    Mario
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/704377

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice