Macro "Freezeheader" cannot be found - Excel

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?

 

Assuming you can load run Excel normally, what's listed under (Tools >) Add-ins?

ETA: Here's a comprehensive checklist from JKP. http://www.jkp-ads.com/Articles/StartupProblems.asp

 

I don't have access to the PC at this time, if something's listed should I untick it?

 

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.

 

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.

 

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?

 

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.

 

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.

 

Gotcha!

 

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

 

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.

 

What is the Excel "start folder"?

 

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

 

Thanks bomb!