One method.

Create a single sheet workbook and save as SHEET.xlt template with the code and
table as you like.

Store it in your XLSTART folder and insert it with this line in your Sheet1
macro code.

Sheets.Add(Type:="Worksheet")

Which will use your SHEET.xlt template as the "added" sheet.


Gord Dibben MS Excel MVP


On 4 Mar 2007 17:37:54 -0800, wrote:

Hi,

I'm creating a workbook that will has an macro on sheet 1 which
creates a new worksheet with a table for tracking jobs.

What I need to do now is add some code to each new worksheet as part
of the macro on sheet 1.

This is where I have no idea what to do. The code on each worksheet is
basically code to run some batch files when a certain cell is
clicked.

What is the best way to do this?

Thanks