VBA BeforeSave Macro

[KLUBKHTY]

Hi, I am new to VBA coding and I need some help.

I wrote a macro and named it Chart.
I want to have my Chart macro run anytime a user goes to save the file and I want the "Chart" changes to be saved also. I don't know how to write the code to make this happen. I've testing several ways and when I hit the save button, it never works, the macro does not run. Any help is appreciated.

 

[Asala42]

It sounds like you're trying to apply a Workbook_BeforeSave Event.

In the VB Editor (specifically the Project Explorer Window), enter the following code in the "ThisWorkbook" section.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Call chart
End Sub

HTH

 

[KLUBKHTY]

Asala,

You are great!!!
I had that code before, just in the wrong section (as a Module). Thank you so much!