Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Form.show not working on opening workbook

  1. #1
    Join Date
    8th August 2011
    Posts
    66

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    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!

  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,343

    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

    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.

  4. #4
    Join Date
    8th August 2011
    Posts
    66

    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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 1
    Last Post: February 12th, 2011, 18:20
  2. Show UserForm Upon Opening File/Workbook
    By downing in forum EXCEL HELP
    Replies: 4
    Last Post: October 17th, 2006, 04:26
  3. Show Message 5 secs After Opening Workbook
    By alienscript in forum EXCEL HELP
    Replies: 2
    Last Post: August 13th, 2006, 11:45
  4. Replies: 3
    Last Post: June 21st, 2005, 02:05
  5. Show UserForm Opening Workbook
    By mileseve1 in forum EXCEL HELP
    Replies: 6
    Last Post: November 28th, 2004, 06:19

Bookmarks

Posting Permissions

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