Copy sheet and make new sheet active

[belvy123]

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

 

[Bob Phillips]

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]

Hi Bob

Hiw is this done???
--
cruchnin numbers

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)

 

[Bob Phillips]

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, Insert>Sheet.


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]

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

 

[Ron de Bruin]

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