Can an event macro be called?

[xCav8r]

He just forgot to delete the end if. Delete it!

[Bob Phillips]

Thanks xld. But I am receiving a compile error on the second last line.

The reasoning behind this macro is that I am using heaps of worksheets and thus compiling a summary page. The linking to worksheets will be perfect (when I get it working ).

Have you considered workbook events?

[jacksonworld]

Still no success.

The reason I want to include it in a module, is that in the particular spreadsheet I am applying this macro, I am already using many other macros. So if I can dump them all together in one module, it would make things much easier.