Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Using the Active cell in one sheet for another sheet | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |