Excel file does not close with the macro for now()

[nr6281]

Hi All,

I am having an issue here I have a macro running to auto refresh a template for ()now formula, Now the macro works fine but the excel wont close I have to kill it in the task manager. And even the copy pasting of data is becoming an issue.

Please help,

Macro in this work book

Please Login or Register  to view this content.

End Sub

Any help appreciated...

[AlphaFrog]

Please Login or Register  to view this content.

[nr6281]

Hi @ AlphaFrog,

Thank you this works perfect