VBA Disable Cancel button on Saving dialogue

dpoag1

New Member
Joined
Feb 2, 2024
Messages
7
Office Version
  1. 2010
Platform
  1. Windows
While the saving box appears there is a cancel button at the bottom right corner. I want to prevent this button from appearing or prevent the saving box to appear all together. Essentially I don't want the user to cancel the save process. Please see the screenshot. Thank you!
 
Last edited by a moderator:

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
I haven't seen that dialog before. Is that an excel built-in saving prompt or a custom one?
 
Upvote 0
Here's a screenshot of the dialog box for reference. Thank you.
 

Attachments

  • 1000012230.jpg
    1000012230.jpg
    144.5 KB · Views: 4
Upvote 0
Yes. I already saw the dialogue when googling this morning.
Did you check the link I posted in my first reply? Is it your anti-virus software that is causing the dlg to appear ?
 
Upvote 0
Yes. I already saw the dialogue when googling this morning.
Did you check the link I posted in my first reply? Is it your anti-virus software that is causing the dlg to appear ?
Thank you for the follow up. I have an email into my it representative to see if it is av-related. I will update as soon as I hear and thanks again.
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,215,097
Messages
6,123,076
Members
449,094
Latest member
mystic19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top