![]() ![]() In the Microsoft Visual Basic for Applications window, double click ThisWorkbook in the left bar, copy and paste the below VBA 1 into the Code window, and then click the Save button. In the workbook you need to disable the Save & Save As functions, please press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ. You can run the below VBA code to disable the Save & Save As options in Excel.ġ. ![]() This article provides VBA method to disable the Save & Save As options in Excel.ĭisable Save & Save As options with VBA code But, sometimes, your Excel file is not allowed to be modified and saved by other users when they read the file. Normally, when we click Save or Save As function, our modified data in the workbook will be saved at once. How to disable or do not allow Save & Save As options in Excel?
0 Comments
Leave a Reply. |