+ Reply to Thread
Results 1 to 4 of 4

How to disable Excel application close by 'X'

  1. #1
    Registered User
    Join Date
    12-16-2020
    Location
    Brisbane, Australia
    MS-Off Ver
    2010
    Posts
    8

    How to disable Excel application close by 'X'

    Attached is a spreadsheet on how to disable excel close 'X' application but still allow your own button to exit and save application.
    Little bit of code in 'ThisWorkbook' apon opening & closing and a little bit in the command button. Simple really.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 02-07-2023 at 11:10 PM. Reason: Revised title, please do not use all caps. Also moved since this is a technique and not a question.

  2. #2
    Registered User
    Join Date
    02-22-2023
    Location
    Canada
    MS-Off Ver
    2021 year
    Posts
    1

    Re: How to disable Excel application close by 'X'

    Hi, thanks, It was very helpful

  3. #3
    Registered User
    Join Date
    02-21-2023
    Location
    London, UK
    MS-Off Ver
    Microsoft Office 2016 x64
    Posts
    10

    Re: How to disable Excel application close by 'X'

    Hello! Thank you for sharing this

  4. #4
    Registered User
    Join Date
    04-12-2023
    Location
    India
    MS-Off Ver
    2019
    Posts
    3

    Re: How to disable Excel application close by 'X'

    worked fine. thanks

+ 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. Disable minimize button on Excel application
    By scouse13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2022, 06:53 PM
  2. About Application.Run and disable ScreenUpdating
    By ikimashu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2022, 03:38 PM
  3. [SOLVED] Disable X Button of Excel Application
    By AmirSoft in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2015, 04:07 AM
  4. How to disable application alerts On workbook opening!
    By Korjaaja in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2014, 12:11 PM
  5. Replies: 0
    Last Post: 08-15-2012, 08:13 AM
  6. [SOLVED] Disable Run-Time Errors "Application.DisplayAlerts = False" Not Working
    By Punx in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-12-2012, 03:03 PM
  7. Disable the "X" close button in an excel application
    By Tempy in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-19-2005, 11: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