Macro that runs on the SaveAs (PDF) event and not the Save event

[Doug-M]

Good evening everyone,

I am working on a workbook with several pages. On each page I am trying to setup a macro that run when the SaveAs event is activated (i.e. when the end user clicks a button to save the current worksheet as a PDF). The macro would add the current date and time (i.e. =NOW()) to a specific cell (B5). Then another macro would activate based on cell B5 now having a value in it. This macro will run on the worksheet change event to highlight (fill with bright orange) any cell that is changed.

The overall idea is that the end user can make updates/changes to a schedule as often as they want and then save the schedule to a pdf. From that save to pdf point onward anything changed on the schedule will be highlighted orange. I am not sure if my idea to have the saveas event fill a cell that then triggers the macro for onchange will work or is the best way. Does anyone have any ideas?

Thank you very much for your help on this!

[bakerman2]

To save as pdf you would use ExportAsFixedFormat instead of SaveAs.