+ Reply to Thread
Results 1 to 5 of 5

Clicking Red X on UserForm produces run-time error '91'

  1. #1
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379

    Clicking Red X on UserForm produces run-time error '91'

    Hey all, quick one for you, I need to make the Red X at the top firght of my user form "End" rather than "Exit Sub" which I think it is trying to do now, as simply exitting the sub returns it to the previous sub which opens the form again. Sorry, been a long day, hope that makes sense.
    Last edited by ChrisMattock; 12-10-2008 at 04:43 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Chris,

    It would help to see all the code. Can you post your workbook for review?

    Sincerely,
    Leith Ross

  3. #3
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    Sadly I can't, it is under the file size limit but it keeps timing out when I try to upload it, I posted the code here earlier -

    http://www.excelforum.com/excel-prog...m-problem.html

  4. #4
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    A search of this forum or a google search of, userform "disable close button", should find many solutions.

    e.g.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    Well my apologies for wasting your valuable time then.

+ 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