macros problems within excel 2007

[ebonneau]

Hi, i'm working in excel 2007 with a workbook that contains macros that is used by an other workbook.

This macroed workbook is in the XLstart folder. It is opened at startup of excel in a hidden window. The unhidden workbook is where i call the macros from the hidden workbook in the xlstart folder.

Every macros work well but the PROBLEM is that sometimes the macroed XLS file gets in error and they are deactivated by the program. I know how to re-activate them but i can't find a solution tu avoid getting in error. Could somebody give me some hints?

By the way, I don't know what is the cause of the error because everythings was working well on excel 2003 but i need to upgrade to 2007 without having these errors

 

[Smitty]

Welcome to the Board!

What's the error?

Without specifics it's gonna' be hard to point you in the right direction.

 

[ebonneau]

That is the problem, the error is not clear to me neither. Let me tell you as much as I can.

This does not occur at each time the excel application opens but some times to times excel deactivate my hidden workbook containing macros and the only cue I have is when I go in excel option then add-in section then get deactivated elements, I can see my workbook containing the macros and it is written as information :

"Elements listed below have been deactivated because they prevent excel of working properly"

(Note, it is a traduction of my french version of office 2007)

That's all I got! The macroed.xls file is still in the xlStart folder even when deactivated and when I reactivate it within excel, I need to restard the application in order to take account of these changes. After reactivating the add-in (xls hidden workbook) I may use it until it gets again deactivated. The occurence is between 4 to 10 times opening a workbook without getting this error.. didn't really count how much time, maybe I should!

Hope I gave you enough to give me a cue or the solution

Thx rick!

 

[Smitty]

You've got me stumped.

Can you post the code?