Copy sheet and make new sheet active
Hi Bob
Hiw is this done???
--
cruchnin numbers
"Bob Phillips" wrote:
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
|