+ Reply to Thread
Results 1 to 3 of 3

Excel UserForm breaks if certain user clicks off form

  1. #1
    Registered User
    Join Date
    11-20-2010
    Location
    Delaware, USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Excel UserForm breaks if certain user clicks off form

    Good Morning,

    I have a relatively (hopefully) simple VBA question.

    One of my co-workers has an issue with a userform that I've created in which when they 'click off' the form, and then try to click back, the VBA editor appears in break mode. They can still use the form if they click back onto it again, but it is annoying that the break window even pops up. This form is used by over 20 other people and no one else has this error. This is a shared workbook as well.

    This user previously has 'code execution has been interrupted' -- but I fixed that by adding "Application.EnableCancelKey = xlDisabled". This error this persists though, any suggestions?

    Thanks, JC

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Excel UserForm breaks if certain user clicks off form

    Do they have any references missing?

  3. #3
    Registered User
    Join Date
    11-20-2010
    Location
    Delaware, USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: Excel UserForm breaks if certain user clicks off form

    I do not believe so-- this error has been happening continuously for the past several weeks. Other people use the same sheet (same references, ect.) and do not encounter the error.

+ 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