Macro (Module) to copy macro (sheet) to a sheet

[tuneloon]

I have a long macro set up which creates multiple sheets with various data which works great.

I would like to add the following code

Please Login or Register  to view this content.

to each of the individual sheets at the end of the macro, so that when the person doing the research is adding specific data they can easily tell which line they are on.

Each of the sheets are added and renamed in the macro

Please Login or Register  to view this content.

I can't figure out how to code the module to add the code to each sheet.


Any suggestions?

[Norie]

Use the workbook level event SheetSelectionChange.

Please Login or Register  to view this content.