.SaveAs doesn't initate 'Workbook_BeforeClose' ?

[Lil2606]

Hi all,

I am working on a macro that makes users click "Enable Content" mandatorily to access the workbook, works like a charm, except I have a macro which does a .SaveAs under a different name, and it automatically closes my original file, but doesn't initiate the "Workbook_BeforeClose" code I have in it.

Is there a way around this?

I do want to close the original doc, but have the "Workbook_BeforeClose" to run in it. I have to have my new workbook to be my active workbook, as the .SaveAs macro does a lot of things to it referring to a workbook object which equals my 'ActiveWorkbook'. (new wb is also an xlsm)

Can someone help me with this?

Thanks!

 

[Fluff]

The original file does not close, you've simply changed the name (and possibly location), hence the beforeclose does not trigger.
Why not put the BeforeClose code into a standard module & then call it from both routines?

 

[Lil2606]

hmmmm........ makes sense I think, I am just not sure how yet... let me give it a try!

 

[Fluff]

Ok, any problems just post back

 

[Lil2606]

Yupp you were right! Perfect solution! Thank you very much! :D

 

[Fluff]

You're welcome & thanks for the feedback