| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create copy of sheet tab (excel 2007) when opening workbook
i have a purchase order with three tabs and it works great.
but i have a new purchase order but when it opens, i want it to create anoter copy of the first tab "Purchase Order" on which the user would enter the required information, leaving the original sheet in tact. any help in this macro would be appreciated. jat |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create copy of sheet tab (excel 2007) when opening workbook
This is a simple one-liner, choose which one would be best for you:
To put the new sheet at the beginning of the book: Sheets("Sheet1").Copy Befo=Sheets(1) or to put it at the end of the book Sheets("Sheet1").Copy after:=Sheets(Sheets.Count) If you want to put it in front of a particular existing sheet (such as Sheet1 itself) Sheets("Sheet1").Copy Befo=Sheets("Sheet1") The newly inserted sheet will become the active sheet. Hope this helps some "jatman" wrote: i have a purchase order with three tabs and it works great. but i have a new purchase order but when it opens, i want it to create anoter copy of the first tab "Purchase Order" on which the user would enter the required information, leaving the original sheet in tact. any help in this macro would be appreciated. jat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 sheet and workbook protection | Excel Worksheet Functions | |||
| Copy a graph within a workbook in Excel 2007 | Charts and Charting in Excel | |||
| Protecting an Excel 2007 workbook with a warning before opening | Excel Discussion (Misc queries) | |||
| Excel 2007 copy/move worksheet to another workbook | Excel Discussion (Misc queries) | |||
| Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
Linear Mode
