Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel Annoyance

  1. Dec 8, 2005 #1

    FredGarvin

    User Avatar
    Science Advisor

    I consider myself a pretty advanced user of Excel, but this one has me stumped. I don't deal with toolbars very often, so I am in uncharted territory.

    I have a group of macros. At one time, when I ran one of the macros, I realized I had a circular argument and it created an error. No biggie. I fixed it and everything is hunky-dory. However, even though I do not have it is specified anywhere, whenever I run the macro again (without the error) the circular reference tool bar pops up in the middle of the screen. I have searched high and low in the basic set up options and I know I have no lines of code loading this toolbar.

    Does anyone know of any place that this tool bar is magically appearing from? It doesn't happen in any other macro or file except the one I mentioned.
     
    Last edited: Dec 8, 2005
  2. jcsd
  3. Dec 8, 2005 #2

    Astronuc

    User Avatar

    Staff: Mentor

    Is this a Macro you created, downloaded or is part of Excel?

    I wonder if it's something in Visual Basic.

    On the other hand - typcial MS. :rolleyes: :grumpy:
     
  4. Dec 8, 2005 #3

    Moonbear

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    Do you get it even in new spreadsheets, or just when you open one that you originally used the macro in? I had a similar problem a few versions ago (haven't used macros since because it annoyed me more than just doing stuff the long way :redface:) that EVERY time I opened a spreadsheet that I had once used a macro in, even after telling it EVERY time to just delete that dang macro and leave me alone, I got a pop-up window telling me there was a macro and asking if I wanted to open it. :grumpy:

    Sorry, I have no solution, just wondering if it's something associated with Excel never forgetting you used a particular macro for some weird reason when you open a file that used it.
     
  5. Dec 8, 2005 #4

    PerennialII

    User Avatar
    Science Advisor
    Gold Member

    .... only thing can come up is that you'd had this

    Application.CommandBars("Circular Reference").Visible = True

    somewhere in your macro, but that is pretty easy to notice & think you've already debugged this option .... :frown: .... perhaps some other bar like 'formula auditing' (which has some of the same tools) can make it appear. Weird.
     
  6. Dec 8, 2005 #5

    FredGarvin

    User Avatar
    Science Advisor

    To answer all in the order presented:

    1) Astro: The macros are all mine. I wrote them. They are part of my personal.xls so they are loaded every time I start Excel.

    2.) Moonbear: It happens only when I exectute that macro. If I load any other workbooks, start new ones, etc... it doesn't do it. It is somehow tied to the macro.

    3.) Perennial: That was the first thing I did look for. I thought maybe a fluke macro record or something happened, but I couldn't find it anywhere.

    I had a somewhat similar problem a while ago with a custom footer that kept getting changed back to an old value. Even after I manually changed it I couldn't figure out why it kept going back to the old version. Then I realized there was a custom format as part of a macro. After I changed that, everything was a-ok. I was thinking this might be somewhat similar, but I haven't been able to find anything like that as of yet.

    I guess I'll just have to copy the macro down and then delete the old one to see if that does the trick. I wonder if it's tied to the workbook somehow and not the macro....? hmmm......
     
  7. Dec 8, 2005 #6

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    try exporting the macro, deleting it from the code tree and then reimport it......
     
  8. Dec 9, 2005 #7

    FredGarvin

    User Avatar
    Science Advisor

    I'll give that a go.

    Thanks everyone.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Excel Annoyance
  1. Excel code (Replies: 1)

  2. Histograms in Excel (Replies: 4)

  3. Excel summing (Replies: 3)

  4. Excel + Calculations (Replies: 9)

Loading...