Hi, Everyone -

I'm continuing to work on our agency Payroll Sheet.... seems like a
"never-ending battle".... ;)

I have a quick couple of questions that I was hoping to obtain some
imput on:

Within my Payroll Sheet, I have what is called a Data Entry Sheet
where the employee manually enters their hours (both paid and Leave),
and the numbers are fed over to the actual Payroll Sheet where
everything is more or less calculated out and summarized. We now have
an employee that will need a SEPERATE Data Entry Sheet for each
project he works on, so that he will have one actual Payroll Sheet but
15 seperate Data Entry Sheets. What I would like to do is to set up a
VBA button that, when pressed, XL will copy the original blank Data
Entry Sheet (along with all formatting and security settings) and
insert the copies sheet as a new sheet. Can someone help me out with
the code strips to make this possible?

Thanks.

Frank