addin not running correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an addin in excel 2002. I load the addin through
tools>addins>browse. It then puts a menu item in the tools menu. I click on
the addin and the userform I created comes up and I hit the ok button on my
userform. It runs for about 30 seconds and then gives me an error. I
noticed I had a GoTo statement between a With and End With. So I cut
everything in the GoTo staement and put it outside the With staement and ran
it again. It ran correctly so I saved the addin file. I then closed excel
and tried to run it again. It did not give me an error message it just quit
running. So I went to the VBE and made sure the code was correct. It was
correct. So I then ran the addin again and it ran fine. It seems like after
a bad run the next one is a good run. Any suggestions to what is causing
this?

Any help is appreciated
 
and made sure the code was correct. It was correct. ....

Not quite.
If you post that code we may have a chance to see what is wrong.

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble Installing Excel VBA Code Cleaner into Office 365 0
Addin Auto_Open code executes only in debug mode 2
Copy a Sheet to an AddIn 2
In what order do installed AddIns open? 2
how to detect if an addin is running 1
Trying to read CustomDocumentProperties of an open 2007 AddIn 1
Addins with isaddin property to false in excel 2007 4
Installing Addin Causes Serious Error in Excel 2002 1

Back
Top