Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.
The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by But after closing and reopening the workbook, you will find the changes were failed to save. Note: It seems that changes are saved in current worksheet every time you modify and save the workbook. The workbook has been saved as an Excel Macro-Enabled Workbook with the Save and Save As functions disabled. Click the Save button to save the code, and then close the workbook.
Sheets(xName & "").Move after:=Worksheets(unt)ĥ. Sheets.Add(after:=Worksheets(unt)).Name = xName & "" If Not Evaluate("=ISREF('" & xName & "'!A1)") Then VBA 2: disable the Save & Save As options in Excel Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Now copy and paste the below VBA 2 into the ThisWorkbook code window. In the opening Save As window, select a folder to save the workbook, name the workbook as you need and select Excel Macro-Enabled Workbook from the Save as type drop-down list, and finally click the Save button.Ĥ. VBA 1: disable the Save & Save As options in Excel Private Sub Workbook_BeforeClose(Cancel As Boolean)ģ. 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 kommentar(er)
