Jul 9, 2018 · You can use Workbook_BeforeSave Event in the ThisWorkbook object to capture the user selecting SaveAs (or using the keyboard shortcut), which would result in the Save As …

Feb 14, 2017 · I want to do this without the prompt that I am getting to make sure I want to save the file. We are using a macro enabled excel file to import the data make changes and then save.

Sep 12, 2024 · Learn how to disable the Save and Save As options in Excel using VBA code. Protect your workbook from unauthorized modifications with this step-by-step guide.

Jan 29, 2016 · To delete the code from ThisWorkbook Class Module (delete every thing) we can use this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As …

Apr 8, 2008 · I cannot see a way you will achieve this without macros (and of course you will be unable to force users to activate macros) although you can make the file unusable (thru …

Apr 18, 2014 · I would like to prevent the user from saving the origial document, but still allow them to use the command button to save it to another location. I have found a few ways to do …

Dec 2, 2012 · It was necessary in order to force the end-user to Save the workbook only through use of a supplied macro which created a highly structured file name. The Auto_Open used the …

Apr 19, 2021 · Using the following code in VBA "ThisWorkbook" to try & disable the Save & Save As functions - but this is not working properly Private Sub Workbook_Open() …

Jul 6, 2020 · You can use the Workbook_BeforeSave event to achieve this, disabling the CommandBars won't stop your users using a shortcut such as CTRL + S. Private Sub …

Jul 11, 2023 · Disable Or Do Not Allow Save & Save As Options. Here we will first insert VBA code to disable the save option, then add another code to the same sheet to disable the save …