Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro (Excel 2000)

    I'm trying to run a macro in Excel 2000, and I want it to be a "relative reference". However, when I try to record the macro, no toolbar comes up that offers me the option of "relative reference". Am I doing something wrong? Also, I'm trying to name the macro DX1050, and for some reason it says that name isn't valid?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel 2000)

    When you run the macro, do you get a small square that pops up that looks like it says Stop Recording on the top of it? If so, there is a button on that square that looks like a spreadsheet. This is the relative button. As far as the macro name, I don't think you can use the numbers. Try another name with just letters (no spaces either).

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel 2000)

    To get the Macro toolbar back, if it won't show at all, when you have the macro recording, you can right-click in the toolbar area and select "stop record", and that toolbar will show up so you can click on the relative button.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel 2000)

    DC1050 can't be used as a macro name because it can be mistaken for a cell address. You should be able to use DC_1050.

    MelanieB has told you where the relative button is.
    Legare Coleman

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel 2000)

    Thanks for the assistance. The problem is, I don't get the button that's supposed to pop up when I record a macro, so I don't get the option of the relative button. Any idea why I don't get the button?

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro (Excel 2000)

    Someone pressed the X instead of the square! Naughty! To get it back, use
    1) Tools | Macro | Record New Macro, note the macro name and press OK.
    2) Right click on the menu bar and click on the Stop Recording toolbar display.
    3) Now you should have the stop recording button, press the stop recording square (NOT the X).
    4) Use the Tools | Macro | Macros menu and delete the macro you just created.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  7. #7
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel 2000)

    It worked! Thank you so much. I must have pressed the "x". I'll try to remember not to do that again.

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro (Excel 2000)

    No problem, my students do it all the time!
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

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

    Re: Macro (Excel 2000)

    So <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> do I! That Excel behavior is -so- annoying. ... and so is my behavior when I do it.
    -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
  •