+ Reply to Thread
Results 1 to 4 of 4

Disabled X button but wish to create 'Exit' button

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    wales
    MS-Off Ver
    Excel 2002
    Posts
    31

    Disabled X button but wish to create 'Exit' button

    I have a workbook (i cannot upload due to restrictions) I have disabled the X button to prevent users from closing via that method.

    I wish to have a user click an Exit button instead as this is capturing some usage data.

    Can someone help please?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Disabled X button but wish to create 'Exit' button

    It would need to be in VBA, and it is possible.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    05-02-2013
    Location
    wales
    MS-Off Ver
    Excel 2002
    Posts
    31

    Re: Disabled X button but wish to create 'Exit' button

    Thank you.

    Could someone help me getting this done please? I have got as far as diabling the X button and that is it.

    cheers

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Disabled X button but wish to create 'Exit' button

    Hi dan,

    Here are a couple of Macros you can use. See the attached workbook for the macros in context.

    Lewis

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Create running stopwatch/timer with 1 button (start/stop). No reset button.
    By leeroy2612 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2021, 12:59 AM
  2. [SOLVED] enable a disabled button
    By CharlieZangel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 07:32 PM
  3. option button disabled
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2006, 03:00 PM
  4. [SOLVED] [SOLVED] Create floating button based on button click in menu
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM
  5. How do i create a command button or macro to exit Microsoft Excel
    By raj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2005, 10:06 AM

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