before save events

Hi all You probably all know the AutoSave in Excel. And probably a lot will know how to disable it with VBA. Sub Workbook_Open() ActiveWorkbook.AutoSaveOn = False End If Situation: When a user is opening this file for the first time, Excel will ask to 'Enable Content' for security...

I have some code that I took from a different Forum post which I've put below. I'm wanting to make it only apply to a specific worksheet names "New Hire Form". Can anyone adjust this do only happen if "New Hire Form" is the selected sheet? Also, do I put it in the "thisworkbook", Sheet, or...

I have this code in VBA which currently works perfectly fine but I want to add to it and cant seem to get my head around it. As it stands, when you press save on the workbook it automatically sends an email to the email address in the code stating the date and time the work book was updated...

I have the following VBA code in a before save event ' check if file exists. if yes save else saveas Application.EnableEvents = False If Len(Dir(FullName)) > 0 Then ActiveWorkbook.Save Else ActiveWorkbook.SaveAs FileName:=FullName, AddToMru:=True End If...

I have a process that is to be triggered Before Save. Excel 2010 64-bit W7. When I open the workbook manually and request a save from the keyboard it works fine. When the same workbook is opened by another workbook and saved by that second workbook's VBA code, the Before Save process is not...

Hello to all. Have a quick one for everyone to mull over. To start, using Excel 2003 (don't say it, I already know :banghead: ). I have a protected sheet with Autofilter boxes located from A4 to Y4. I need to be able to have a macro check the columns to see if any of the filters are active...

Hi there, I'm new in the forum. Hope some kind soul helps :) I wrote this code without many idea of VBA thanks to the search tool: Private Sub Workbook_BeforeSave(ByVal SaveAsUi As Boolean, Cancel As Boolean) Dim msg As String With Sheets("Form") If WorksheetFunction.CountIf(.Range("C5")...

(Excel 2007) I have a workbook with several sheets with cells that require user input. Some fields are not that important, but others are very critical. All the critical fields say 'Required', but I still get people returning the workbook with no entry in these fields. I need a before-save macro...

Please help. I'm fairly new to VBA. and I cant seem to figure out why my code isn't working. If I save manually, the Workbook_beforesave macro executes just fine. However If my macro calls to save, the beforesave macro doesn't execute any of the code at all! I step into and it just acts like its...

This was offered as a solution to another's post... http://www.mrexcel.com/forum/showthread.php?t=465898 but I got a bug in it. I've got the following code to save a copy of the current file to another location... (To test this out, I used my Desktop[shared] and My Documents[master] as the two...

Would like code to not allow save or close if cells P9 through R27 have ? Instead of blank. Thank you for any assistance.