before save

Hello, I have a problem with my Private Sub BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) and it's driving me nuts ! I hope somebody will be able to help. I had a code to cancel every save and it worked ! (th code down there) Private Sub Workbook_BeforeSave(ByVal SaveAsUI As...

Hello! I am attempting to use the BeforeSave event to check whether any of the checkboxes are selected before allowing the user to save the workbook. Please see my code below. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "Entered Sub...

Hi, How can I edit this code to repeat the check on the next row? I would like the code to check ranges B3:B9, B12:B18, B21:B27, B30:B36, L3:L9 before closing to ensure that the user cannot close the form before editing all cells. I should note that usually only one row will be completed at...

Ok, I'm getting nuts. I have an Excel file with Checkboxes on sheet 'RBD' I have a checkbox for each title. And each title has several checkboxes for the options |_| ANIMALS ....|_| Cow ....|_| Pig ....|_| Chicken ....|_| Other |_| FLOWERS ....|_| Rose ....|_| Tulip ....|_|...

I am creating vba script that runs on the Workbook_BeforeSave Declaration, which validates several things in the file. I have the validations working correctly, but the file still saves, even if the errors aren't corrected. I want to ensure that the file will not save unless the corrections...

Hi, I'm fresher in vba ,This particular excel is meant to be put in a share folder where team members are supposed to fill it. I want to popup a error message before saving. The requirements are 1.In a row , the highlighted columns must be filled(error msg before save if not filled) 2.select...

Hi I've got a spreadsheet that several people use, some of them regularly hide columns to make it easier to look at while they work, the problem is the forget to unhide the columns once they're done, I've figured out how to stop this with a 'Workbook_BeforeSave' private sub that unhides all...

Hello all, I am using Excel 2010. I am attempting to run a macro as a 'Before Save' event in a workbook named "FirstWorkbook.xlsm." Among other things, the macro opens up a separate workbook ("SecondWorkbook.xlsm"), copies a range of data from the first workbook, pastes the data into the...

I was looking for a solution to force users to fill in certain fields on a macros enabled excel, and today i've found this solution that worked as a charm, the only issue is that I as the autor need to close the file with the blank fields so it gets to the user ready to fill in, and this macros...

I use Excel 2010 64 bit W7, although I doubt that is important here. All the message boards say that a save by VBA should trigger a Before_Save event macro in the workbook being saved. It does not for me. I remember reading in an MSDN document on a related issue the offhand comment that Oh, by...