Why not add a sheet template to your XLSTART directory, and then they can
simply insert this.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"belvy123" wrote in message
...
Hi All

I have a worksheet that I want to be able to do this.
I want to use a macro using CTRL(A) to copy a sheet in my workbook and to
make it active. I want the sheet that it copys from to be hidden and to
use
the same sheet each time that a copy is made. This way I have a new blank
sheet to start off each time I need a new sheet. I want to do this so the
people on my team at work do not have to do anything more that a CTRL(A)
and
be able to start in to work and not have to go to the top menu and select
insert etc.

Thanks
crunhin numbers