Copy worksheet without copying named ranges

[dhregan]

I have a worksheet titled "Template" which I use to generate new worksheets for different locations. Within "Template", I have several defined (named) ranges. I have a macro that takes the row values of a pivot table and generates copies of the "Template" worksheet, with these copies renamed to the value of the corresponding row from the pivot table. For example, Mr. Smith and Ms. Jones are salespersons who have clients in different states. I have a pivot table that shows the number of clients (data area in the pivot table) each salesperson (columns in the pivot table) has within each state (rows in the pivot table). My macro cycles through each of the salespersons and creates separate workbooks containing worksheets based on the "Template." When this is done, each "state" worksheet in a salesperson's workbook contains the defined ranges. Is there a way not to copy the defined ranges into each new "state" worksheet?