workbook_beforesave

Good day, I have a worksheet that have mandatory fields across multiple sheets that I need completed. However, these mandatory fields only become mandatory if they complete Column A, which is like an employee code. I also have mandatory fields that are dropdowns, but need to be selected (once...

I am trying to have this macro run before every save, to ensure that the two totals in question are matching. It only runs the first time I press ctrl+s ThisWorkbook: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Call ExtendedTotalCheck End Sub...

I have some code that I have put in Workbook_AfterSave and Workbook_BeforeSave. It works great and does exactly what I want; however, during testing, I found an odd situation where Excel doesn't call these two functions when saving a document (maybe Excel is disabling events on its own here)...

Hi all, I have a Worksheet_Change function and a Workbook_BeforeSave function in my master file. When the user selects a specific value in the target field of the worksheet, it will cause the workbook to save. The BeforeSave function kicks in and attempts to send updates to/get updates from a...

Dear Sir/Madam, Good Day!! I'm stuck with a strange problem and can not get any solutions. Problem: I have a macro enabled workbook say ABC.xlsm. I have code in ThisWorkbook for saving the file while closing. Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub and...

I have been successfully using the Workbook_BeforeSave macro to ensure that users of my workbooks always save as a macro enabled workbook. This works fine when the user presses the "Browse" button, or the "More options..." link on the Excel 2016 File/Save As page. However, it is also possible...

Hi all, this one is causing me a bit of a problem. Hope i get the problem across !. I have a template which i update regularly, this template gets used daily, and files are saved from it. Over the years we have lots of these files. People open old versions of these rather than using the new...

The code I am presenting is simplified for illustrative purposes but essentially the Workbook_BeforeSave routine cycles through each sheet in my workbook and applies some formatting. This worked in excel 2003 but quit working after converting to excel 2013. I have a XLSM workbook with 3 sheets...