Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a sheet using a template
Hi,
I am adding a sheet using sheets.add.name = sname - no problem However, I would like the newly created WORKSHEET to be based on a template. Is this possible? if yes, how? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a sheet using a template
NB I don't want the worksheet to be the default for all workbooks only the
workbook that I am adding the sheet to "Newbie" wrote in message ... Hi, I am adding a sheet using sheets.add.name = sname - no problem However, I would like the newly created WORKSHEET to be based on a template. Is this possible? if yes, how? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a sheet using a template
One way, if what you're doing is regularly adding a new
sheet to an existing workbook. Create your template worksheet, place it right at the end of the workbook, then hide it or, if you're concerned about other users finding it and messing about with it use Sheets("Template").visible = xlveryhidden Then, to create a new copy: Sheets("Template").visible = true Sheets("Template").copy befo= Sheets("Template") Activesheet.name = "NewSheetName" Sheets("Template").visible = xlveryhidden Cheers, Pete -----Original Message----- Hi, I am adding a sheet using sheets.add.name = sname - no problem However, I would like the newly created WORKSHEET to be based on a template. Is this possible? if yes, how? Thanks . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a sheet using a template
Thanks works a treat!
"Pete McCosh" wrote in message ... One way, if what you're doing is regularly adding a new sheet to an existing workbook. Create your template worksheet, place it right at the end of the workbook, then hide it or, if you're concerned about other users finding it and messing about with it use Sheets("Template").visible = xlveryhidden Then, to create a new copy: Sheets("Template").visible = true Sheets("Template").copy befo= Sheets("Template") Activesheet.name = "NewSheetName" Sheets("Template").visible = xlveryhidden Cheers, Pete -----Original Message----- Hi, I am adding a sheet using sheets.add.name = sname - no problem However, I would like the newly created WORKSHEET to be based on a template. Is this possible? if yes, how? Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template for Balance sheet | New Users to Excel | |||
How to merge data in Excel - one sheet to template sheet? | Excel Worksheet Functions | |||
time sheet template available | Excel Discussion (Misc queries) | |||
Making a spread sheet template | New Users to Excel | |||
First Sheet,First column as template | Excel Programming |