Consulting

Results 1 to 7 of 7

Thread: Solved: Building add-in errors

  1. #1

    Solved: Building add-in errors

    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

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Do they work before you save them as an addin?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    VBAX Master
    Joined
    Jun 2007
    Location
    East Sussex
    Posts
    1,110
    Location
    What code do you have in the Initialize and/or Activate events of the two forms?
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Quote Originally Posted by lucas
    Do they work before you save them as an addin?
    yes, without any problems.

  5. #5
    Quote Originally Posted by rory
    What code do you have in the Initialize and/or Activate events of the two forms?
    no code in there...

  6. #6
    VBAX Master
    Joined
    Jun 2007
    Location
    East Sussex
    Posts
    1,110
    Location
    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.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •