disable save as

  1. A

    VBA When Opening File

    Hi All, I'm semi experienced with VBA codes but have never written one to run upon the document opening. I tried following this guide Run a Macro Automatically on Opening Excel Workbook - VBA Examples but couldn't get it to do what I want it to do. 1. Essentially I want users to have the...
  2. B

    Application.DisplayAlerts=False & ActiveWorkbook.Saved=True Not Disabling Save Prompt at Close

    I am using TaskScheduler to open a spreadsheet to run an Auto_Open subroutine. The Auto_Open subroutine calls various subroutines to pull data from a server, perform calculations, update charts, export pdfs, and send emails. At the end of Auto_Open, a timed popup allows user intervention to stop...
    • bruce42392
    • Thread
    • activeworkbook.saved application.displayalerts close a workbook close excel disable save as
    • Replies: 5
    • Forum: Excel Questions
  3. A

    Custom Diagloge Before Closing a Workbook *** Help Please ***

    Hi - I am trying to put in a custom dialogue & warning before an user closes the workbook. The code is working fine in all basic / primary requirements with the exception of a small glitch. When user tries to close the workbook, the code will give a warning to the user. If user hits "No" code...
    • amisagi
    • Thread
    • close workbook custom close workbook disable save as file closing behaviour
    • Replies: 5
    • Forum: Excel Questions

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