before save events

  1. R

    Disable AutoSave after 'Enable Content' but Before 'WorkbookOpen'

    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...
  2. G

    How do I make a macro only affect a single worksheet?

    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...
  3. C

    VBA Email when save problems! Need help with attachments and multiple email address'

    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...
  4. K

    Issues with Saveas on activeworkbook

    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...
  5. J

    Save by VBA does not trigger Save Event

    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...
  6. R

    Autofilter turn off question

    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...
  7. M

    Mandatory Cells Before Saving; IF Statement: Message box problem

    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")...
  8. W

    Require Cell Entry before saving

    (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...
  9. D

    Workbook_BeforeSave Not executing commands

    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...
  10. paipimenta

    Disable Events not preventing crash....

    This was offered as a solution to another's post... 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...
  11. 3

    before save/close

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back