PDA

View Full Version : Solved: Building add-in errors



Sephir
09-17-2007, 06:55 AM
Hello!

I am trying to build small add-in and I'm getting error on this:
frmSplash.Show vbModeless > method worksheets of object global failed!

also I have form frmA and when i call frmA.show i get this error > object doesn't support this property or method?

What's wrong with it?

thanx

lucas
09-17-2007, 07:16 AM
Do they work before you save them as an addin?

rory
09-17-2007, 07:33 AM
What code do you have in the Initialize and/or Activate events of the two forms?

Sephir
09-17-2007, 11:39 PM
Do they work before you save them as an addin?

yes, without any problems.

Sephir
09-17-2007, 11:41 PM
What code do you have in the Initialize and/or Activate events of the two forms?

no code in there...

rory
09-18-2007, 03:50 AM
I think we'd need to see the add-in - I don't see how showing a userform could give you an error about worksheets unless there is code in the startup events for the form.

Sephir
09-18-2007, 05:21 AM
I have to apologize to all of you! I am the BIGGEST IDIOT in this universe! I forgot to delete some old code from the form...