+ Reply to Thread
Results 1 to 3 of 3

Excel freezes after Userform opens

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418

    Excel freezes after Userform opens

    Good Morning All

    The attached workbook only has 1 page with a button to open the Userform. The Userform only has an Exit command button.....

    When the Userform opens, excel freezes and won't close the Userform either by the button or the red X..

    I have never come across this before and I have obviously done something....

    Would anyone know what is making it do this

    Many thanks

    Jim
    Attached Files Attached Files
    Last edited by JamesT1; 06-17-2022 at 12:12 PM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Excel freezes after Userform opens

    The userform is not Enabled. This also affects child controls (the button) even if their Enabled property is set to True

  3. #3
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418

    Re: Excel freezes after Userform opens

    cytop

    many thanks for that,,, I hadn't noticed it,, must have accidently changed it when I was changing the font,,, something toi remember for the future

    many thanks

    JT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] the code works, but the UserForm freezes for half a minute.
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-27-2015, 05:30 PM
  2. [SOLVED] Userform opens on different screen than Excel Program
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2013, 07:24 PM
  3. .vbs that opens userform wont close excel process
    By jayinthe813 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2012, 08:29 AM
  4. UserForm freezes after delete from Listbox
    By NewExcelVBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2011, 02:34 PM
  5. Excel opens slowly and sometimes freezes up computer
    By hereami in forum Excel General
    Replies: 2
    Last Post: 10-21-2009, 09:57 PM
  6. [SOLVED] userform freezes
    By flow23 in forum Excel General
    Replies: 1
    Last Post: 11-24-2005, 01:00 PM
  7. Replies: 1
    Last Post: 07-27-2005, 05:25 PM

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