ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to fix "complie error:procedures" in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/96395-how-fix-complie-error-procedures-excel.html)

Cris Liu

How to fix "complie error:procedures" in Excel?
 
This error message pops up everytime I open Excel.

Gord Dibben

How to fix "complie error:procedures" in Excel?
 
Cris

There must be more to the error message than you have shown.

Perhaps more like this.........

Whenever entering Exec, I get the error message: Microsoft Visual Basic:
Compile error in hidden module: AutoExecNew.
on exit, the error message reads: Microsoft Visual Basic: Compile error in
hidden module: DistMon.

Read the info here........... http://support.microsoft.com/?kbid=307410


Gord Dibben MS Excel MVP

On Tue, 27 Jun 2006 13:00:02 -0700, Cris Liu
wrote:

This error message pops up everytime I open Excel.



Cris Liu

How to fix "complie error:procedures" in Excel?
 
Thanks Gord. The whole message I have is "Microsoft Visual Basic: Compile
error in hidden module: Procedures". I looked at the link you send, and I
didn't have the Pdfmaker file as mentioned.

"Gord Dibben" wrote:

Cris

There must be more to the error message than you have shown.

Perhaps more like this.........

Whenever entering Exec, I get the error message: Microsoft Visual Basic:
Compile error in hidden module: AutoExecNew.
on exit, the error message reads: Microsoft Visual Basic: Compile error in
hidden module: DistMon.

Read the info here........... http://support.microsoft.com/?kbid=307410


Gord Dibben MS Excel MVP

On Tue, 27 Jun 2006 13:00:02 -0700, Cris Liu
wrote:

This error message pops up everytime I open Excel.




Dave Peterson

How to fix "complie error:procedures" in Excel?
 
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

Cris Liu wrote:

This error message pops up everytime I open Excel.


--

Dave Peterson

Gord Dibben

How to fix "complie error:procedures" in Excel?
 
Cris

Close excel and in the run command in the start menu do
excel.exe /s

This starts excel in safe mode and suppresses the loading of addins and
files in the xlstart directory.

If that avoids the message, then close excel. Move any files out of your
excel start directory. and try opening excel again. If that cures the
problem, then it is one of those files. Move back individually to
identify.

If that doesn't clear it, then do a similar procedure with your addins.

Try unchecking all your addins in toolsAddins, Then adding them back one
at a time until you encounter the error.

Of course, you know what you have been doing - so thinking of recent changes
may dramatically narrow the items you need to search.

Above suggestions courtesy of Tom Ogilvy


Gord


On Tue, 27 Jun 2006 14:07:04 -0700, Cris Liu
wrote:

Thanks Gord. The whole message I have is "Microsoft Visual Basic: Compile
error in hidden module: Procedures". I looked at the link you send, and I
didn't have the Pdfmaker file as mentioned.

"Gord Dibben" wrote:

Cris

There must be more to the error message than you have shown.

Perhaps more like this.........

Whenever entering Exec, I get the error message: Microsoft Visual Basic:
Compile error in hidden module: AutoExecNew.
on exit, the error message reads: Microsoft Visual Basic: Compile error in
hidden module: DistMon.

Read the info here........... http://support.microsoft.com/?kbid=307410


Gord Dibben MS Excel MVP

On Tue, 27 Jun 2006 13:00:02 -0700, Cris Liu
wrote:

This error message pops up everytime I open Excel.






All times are GMT +1. The time now is 03:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com