Thanks steve... i will have a play with your sugestions.. can you tell me how
to bind it to the button i have placed on the work sheet. also can i protect
the saved copy so it cant be edited, and the number in the origanal template
must be protected from editing except when the 1 is added at the save

Tom... it is a template (though not saved in the template directory (saved
to desk top)) i say the origanal as it will creat another copy with a new
name and data when i save it,
thanks for your code i will give it a try and let you know

thanks :)