Generate a Private Sub from a Macro?

Hi community,

I have a macro that generates a report, the code is pasted into a module and I just run it.
I have another code which is a private sub, that highlights the currently selected cell to help me focus.
This code is pasted into the worksheet editor and not in module.
I was wondering if there is a code that I just paste in module which then generates the code in worksheet automatically?
Would love to avoid pasting that highlight cell code every time I am doing the report which is twice a week.
Any help from an Excel genius would be greatly appreciated.

Here is the highlight cell code by the way.

Please Login or Register  to view this content.

Hi Holger, this is exactly what I was looking for. Amazing! You are a genius. Sauber! Vielen lieben Dank! :-)