Hi all,

I have written a macro -- let's call it web_macro -- to import some
web pages into Excel. The macro then reformats the pages. It's all
done automatically. I then share the resulting file -- let's call it
"new_file" -- with my friends. The web_macro is in my personal.xls
file.

What I want is that whenever my friends close the new_file, a message
will be displayed. I know I can do it by adding a workbook_beforeclose
event to ThisWorkbook in the new_file. However, I don't want to do it
every time a new_file is generated. How can I code it in my original
web_macro so that a Workbook_BeforeClose event will be inserted to the
new_file automatically?

Your help will be much appreciated!