Copy sheet and make new sheet active
 

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

Copy sheet and make new sheet active
 

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

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

Copy sheet and make new sheet active
 

Open a new workbook and delete all but one sheet.

Customize that single sheet as you wish then save this as SHEET.XLT in the
XLSTART folder also. It then becomes
the default sheet when inserted into any workbook, InsertSheet.


More can be found on this in Help under "templates"(no quotes).


--
---
HTH

Bob


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



"belvy123" wrote in message
...
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

Copy sheet and make new sheet active
 

Hi Again Bob

Ok I did that but now when I open a new book or any existing book that page
shows up first then it goes to a blank or to the page of the existing file I
opened
What causes this
--
cruchnin numbers


"Bob Phillips" wrote:

Open a new workbook and delete all but one sheet.

Customize that single sheet as you wish then save this as SHEET.XLT in the
XLSTART folder also. It then becomes
the default sheet when inserted into any workbook, InsertSheet.


More can be found on this in Help under "templates"(no quotes).


--
---
HTH

Bob


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



"belvy123" wrote in message
...
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

Copy sheet and make new sheet active
 

See
http://www.rondebruin.nl/sheettemplate.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"belvy123" wrote in message ...
Hi Again Bob

Ok I did that but now when I open a new book or any existing book that page
shows up first then it goes to a blank or to the page of the existing file I
opened
What causes this
--
cruchnin numbers


"Bob Phillips" wrote:

Open a new workbook and delete all but one sheet.

Customize that single sheet as you wish then save this as SHEET.XLT in the
XLSTART folder also. It then becomes
the default sheet when inserted into any workbook, InsertSheet.


More can be found on this in Help under "templates"(no quotes).


--
---
HTH

Bob


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



"belvy123" wrote in message
...
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