+ Reply to Thread
Results 1 to 3 of 3

VBA Disable Cancel button on Saving dialogue

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    847

    VBA Disable Cancel button on Saving dialogue

    Dear Experts,

    I am looking for the VBA for disable the "Cancel" option while Saving dialogue prompt. Request to you kindly do provide the solution.

    Your precious contribution would be highly appreciated.

    Many thanks and kind regards,

    Neilesh

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: VBA Disable Cancel button on Saving dialogue

    Why would you want that?

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    847

    Re: VBA Disable Cancel button on Saving dialogue

    Dear Expert, I do have a important financial dashboard where i have created a userform for specific users with password to login to the workbook that userform appears while opening the workbook but if anyone click on the "X" (Close) option in userform then the workbook prompting close command with Save, Don't Save and Cancel option and if i do use the Cancel option then the workbook would be accessible for anyone.

    That is the reason if any unauthorized person tries to access the financial numbers then he would not able to view the financials.

    Another way i was thinking if we can disable the "X" (Close) button via VBA from the userform that would also be work.

    Request to you please do help me out.

    Many thanks and kind regards,

    Neilesh

+ 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] prevent cancel during save as dialogue box
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2017, 09:55 AM
  2. How do I disable the cancel button for a userform?
    By Evalis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2010, 04:14 PM
  3. Cancel Pushbutton on Dialogue Box
    By AccountantCost in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-08-2009, 02:08 AM
  4. [SOLVED] How to disable dialogue box
    By Kapil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 09:35 AM
  5. [SOLVED] Disabling 'Cancel' option when saving work (Yes/No/Cancel)
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2006, 04:35 PM
  6. Disable Dialogue Box To Save & Replace File
    By Dolphinv4 in forum Excel General
    Replies: 2
    Last Post: 10-24-2005, 12:42 AM
  7. Capturing Cancel button on save file dialogue
    By Tanveer_asim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2005, 08:05 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