Runtime error 1004 while loading Add-In

**PVBERG** · 07-06-2009, 08:26 PM

Hello:

I have a workopen event as follows:

Please Login or Register  to view this content.

The workbook is saved as an xlam file.

If I open this file after Excel 2007 loads with file open menu
everything is fine. The code runs without error and
the helpcontext etc work just fine.

Now if I load the file as an add-in through the add-in
manger using the Excel Option menu it again works just fine.

But if I close Excel and then Open Excel (so that add-in
loads automatically) I get an error message that says:

Run-time error '1004'
Cannot edit a macro on a hidden workbook. Unhide
the working using the Unhide command.

Can someone help so that the code works when
add-in is loaded automatically?

Thanks.

**Andy Pope** · 07-07-2009, 05:10 AM

How about placing the code in a routine within a standard code module and calling that using the OnTime method

Thisworkbook object

Please Login or Register  to view this content.

Standard code module

Please Login or Register  to view this content.

**PVBERG** · 07-07-2009, 12:59 PM

Hello Andy:

Thank you so much for your suggestion. It solved the problem.

If you are willing could you explain what the difference is between
the method you suggested and a plain call to the routine such as
Call AssignedHelp? (I first did it this way and it did not work. I posted
the code I did because it was more direct.) Particularly since
the time you added to "now" is apparently zero. I guess
I would be less confused if you had suggested that I add
a small amount of time to delay the call.

Again thanks for your help

Pieter

**Andy Pope** · 07-08-2009, 04:16 AM

apparently the small delay in processing the command via the ONTIME rather than a direct Call allows excel to untwist it's knickers.

**PVBERG** · 07-12-2009, 04:22 PM

Hello:

Thanks again for the information. I have played with it a little more and I think you are right. I have tried loading Excel a number of times and there were a few times that I still got the error, so it may just depend on what else is going on. So to make sure I have added a slight amount of time to the NOW to insure that even if it processes very quickly there will be a sufficient delay. I have not had a failure since.

Pieter