Announcement

Collapse
No announcement yet.

Form.show not working on opening workbook

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Form.show not working on opening workbook

    Hi, I have a project which i used to use on a different computer. When i used to open the excel project a user form used to display upon opening. Now on the new system it wont open. instead i get " Cant move the focus to the control because it is invisible, not enabled, or of a type that does not accept the focus."
    I have searched for an answer but none seem to have helped. Please can any help me?

    Cheers,
    Nobby

  • #2
    Re: Form.show not working on opening workbook

    Sounds like there might be a problem in the Initialize/Activate event of the userform.

    What code do you have there?
    Boo!

    Comment


    • #3
      Re: Form.show not working on opening workbook

      Which version of Excel and do you have a Calendar Control on the form?
      Hope that Helps

      Roy

      New users should read the Forum Rules before posting

      For free Excel tools & articles visit my web site

      If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

      RoyUK's Web Site

      royUK's Database Form

      Where to paste code from the Forum

      About me.

      Comment


      • #4
        Re: Form.show not working on opening workbook

        hi guys, Thanks for your responses, I have managed to resolve it now. I was being slightly special i was looking at the wrong issue. It wasnt showing because of another issue which i managed to resolve.

        Many thanks anyway..............No doubt i will require your assistance in the near future though.

        Nobby

        Comment

        Working...
        X