+ Reply to Thread
Results 1 to 3 of 3

Runtime errors loading userforms & hiding excel

  1. #1
    Registered User
    Join Date
    10-04-2009
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    72

    Exclamation Runtime errors loading userforms & hiding excel

    Hi All

    I was wondering, is there a way to force a userform to load up when you start up excel? At the moment I have put in a bit of script in the "Workbook" module,

    Please Login or Register  to view this content.
    But occasionally when I open the workbook it comes up with a runtime error and says it was unable to create an object or something rather than showing the userform, but i need the userform to be shown every time without fail.

    I also need the userform to be the only thing showing with the excel program itself minimised in the system tray so the user cannot view the sheets of the workbook and i also need the user not to be able to close the welcome userform. Is there a way this can be done at all?

    Many thanks

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Runtime errors loading userforms & hiding excel

    All is possible,however hiding the application can cause problems if you don't know what you are doing. See this post

    Does the object error occur on different computers?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    10-04-2009
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Runtime errors loading userforms & hiding excel

    The error occurs on all computers at work but never on my computer at home... :-)

    Thanks for your help by the way :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1