Insert Macro when new worksheet is created

[RhodEvans]

I have a macro that creates new sheets for me from scratch. I need a macro (Sub TOfC) to be inseted in the Private Sub Worksheet_Activate() section. Is there a way of doing this. (If it helps the Sub is in a module called TOC).I am way out of my league with this one, so any help would be VERY greatly received.Thanks in advance for all of your advice.

 

[Andrew Poulsom]

If you have a worksheet that already contains the VBA code, the code will be copied when you copy the worksheet.

 

[RhodEvans]

Appologies I don't think I was clear in my last post/request. The sheet is a dynamic Table of contents that uses hyperlinks to navigate. This is deleted and created new when the spreadsheet is opened so the hyperlinks stay current. So the problem is that is is not copied each time, but created from scratch.

 

[Andrew Poulsom]

Sorry, I don't understand why you need to delete the sheet and create a new one. Why can't you use the existing sheet after clearing the contents of or deleting all the cells?

 

[RhodEvans]

Basically because, sometimes I can be an idiot and a little single focussed. So when I thought that that was how It needed doing I lost sight of the fact there was a much simpler way of doing it. Thank you very much I have edited the code so it doesn't delete the sheet each time and am feeling embarassed for wasting your time. Thanks again.