Macro not runnning automatically

[NoxGalleon106]

Hi,

I am working on a macro where it should automatically save PDF when the value for 2 cells in different sheets is not blank.
I have the below code but it does not run automatically, I have to press the "play" button in the module for it to run.

Please help check if there is something wrong with the code. Thank you.

Sub pdf()
Application.EnableEvents= False
If worksheets("fi").range("c58").value <> "" and worksheets("m").range("c58").value <> "" then
ActiveWorkbook.ExportAsFixedFormat_
Type:=xlTypePDF,_
Filename= "K:\Treasury\Daily\ " &_
"checklist" & ".pdf",_
quality:=xlQualityStandard,_
IncludeDocProperties:=False,_
IgnorePrintAreas:=True,_
OpenAfterPublish:= True
Application.EnableEvents=True
End sub

 

[Michael M]

The code would need to be in a Worksheet_Change module or called by another macro that makes changes to those cells !
A macro cannot run without some form of trigger !