Compile error in hidden module : MenuHandling

[marcco]

Hi a spreadsheet that was created in excel 2000 , on opening in excel 2003
the compile error comes up. and stops all macros from running . any ideas how
to fix this? I used to use this a lot and not sure if i can roll back to
excel 2000 (corp. IT policies)

marc
(e-mail address removed)

 

[Dave Peterson]

I've never heard of this "menuhandling" error. But the "compile error in hidden
module" means that there is an error in one of the VBA routines in a workbook's
project that is protected.

You could do some detective work to find the culprit.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

 

[Bob Umlas]

Go to the VBE and use Debug/Compile & the culprit should be highlighted.

 

[Robert Flanagan]

The three most likely causes:

1) an error in your code. Doing what Bob suggested will find that

2) A missing reference. Select in VB editor Tools, References. If the
missing reference is to the refedit control, unchecking normally solves.

3) A problem with the installation of Office. Steps to solve are found at
http://www.add-ins.com/how_to_repair_office.htm

Let us know how things go.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel