You sure about that Tom? If it is xlSheetVeryHidden then I think you do
have to make it visible before you copy it with this method. When I
remove the visible lines Excel throws up an error.....

Neil,
Create your TemplateSheet and hide it. Then...
RightClick over the sheet tab name for Sheet A and select 'View Code'.
Then paste in the code I wrote into the VB Window that comes up,
changing 'Sheet3' to 'Sheets("YourTemplateSheetNameInQuotesHere")'

Assuming Sheet A is the first sheet in your workbook, this will now
spit out a template sheet every time you manually change or add a value
in column B of Sheet A.

Personally, I would consider a command button to do this instead..

Hth,OJ