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.

Macro "Freezeheader" cannot be found - Excel

Discussion in 'Business Applications' started by Lucky5tar, Oct 8, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. Lucky5tar

    Lucky5tar Thread Starter

    Joined:
    Aug 2, 2008
    Messages:
    279
    This happens when trying to "freeze panes".

    When booting Excel using "/Automation" problem is still there.

    When booting in safe mode the problem has gone.

    Did some research, said the .XLB file may be at fault, however, I've renamed the existing one and the problem persists.

    Any ideas?
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
  3. Lucky5tar

    Lucky5tar Thread Starter

    Joined:
    Aug 2, 2008
    Messages:
    279
    I don't have access to the PC at this time, if something's listed should I untick it?
     
  4. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    As it states, it's a process of elimination thing in case an add-in's your problem.

    Excel Add-ins.

    1. Tools, Add-ins
    2. note which are checked
    3. Uncheck all (but one)
    4. Restart XL
    5. If no error, check the next one and repeat from step 4.
     
  5. Lucky5tar

    Lucky5tar Thread Starter

    Joined:
    Aug 2, 2008
    Messages:
    279
    I've already followed that guide.

    The error didn't disappear, therefore it shouldn't be an add in problem as I detailed in my first post.
     
  6. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    I wouldn't know which guide you've checked, nevertheless "it shouldn't be an add in problem" may not be correct since "some COM addins are not shown in the user interface and can only be unloaded from the registry".

    Has "Detect & Repair" been tried?
     
  7. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    While in Excel (safe mode, what-not), right-click an empty toolbar space, in the dialog box add a command button, search for the "COM Addins" button. It's not visible by default. After adding it, close the dialog box, navigate to it and see if you have anything installed.

    Also check your Excel start folder. If anything is in there, move them out of it. Do you have a Personal.xls file? It may be corrupt also.

    @bomb: In your list, step #3 you say to uncheck all but one. Which one, and why? Just curious. :)
     
  8. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    It's JKP's list. He means "uncheck all except one", i.e. start with the minimum number (if # is >=1), then work back "up". Accordingly, which one makes no odds. :)
     
  9. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
  10. Lucky5tar

    Lucky5tar Thread Starter

    Joined:
    Aug 2, 2008
    Messages:
    279
    Yes

    I don't see any option to add a command button?

    All I see are ticks next to the toolbars currently visible.

    Will have a look for Personal.xls :)
     
  11. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    That should've read:

    "right-click an empty toolbar space and click 'Customize'. In the 'Customize' dialog, select the 'Commands' tab, and 'Tools' under 'Categories'. Scroll down 'Commands' to locate 'COM Add-Ins' and drag it to your toolbar. After adding it ..."

    and so on.
     
  12. Lucky5tar

    Lucky5tar Thread Starter

    Joined:
    Aug 2, 2008
    Messages:
    279
    What is the Excel "start folder"?
     
  13. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    See the guide you've already followed:

    On WIndows XP it may be a path like this:
    C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART
     
  14. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Thanks bomb! :)
     
  15. Sponsor

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/757217

  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