Excel form on worksheet open doesnt always load correctly

Posted on 2009-12-18
Last Modified: 2013-12-26
Hi folks,

I am using Excel 2007, I have a userform that is opened when the worksheet is opened, the problem that I am having is that when the spreadsheet is opened from a network location its still loads the form but none of the buttons on the form actually work, it works fine when opened locally, it is not 100% of the time this happens. I have plenty of Doevents and have turned off auto calc, the user form only reads from two ranges from the worksheet so its not doing anything to strenuous. Has anyone else come across this problem? Unfortuantley I cant upload the spreadsheet or code for legal reasons.
Question by:m3housing

    Author Comment

    also the spreadsheet is only 2,828kb. And im using a 100 mbit network with a workstation with 2 gig or RAM
    LVL 45

    Expert Comment


    Please provide all the VBA code you have in the file - particularly the code 'behind' the UserForm.

    Also please provide a screenshot from the IDE of the Userform. If you don't have screenshot capture software you could install MWSnap from:

    It produces very compact files and is configurable so that the screenshots can be automatically saved to a specific folder without doing anything.

    or just use CTRL+PrintScrn and Paste into a Word document.


    Accepted Solution

    resoved the problem, the issue is that the form model was set to true, when I set it to false it works fine.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now