Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing "Sheet1"
Hi, When creating a new workbook, how do I remove or hide the defaul worksheet ("Sheet1") after creating my worksheets? I do not want to us the specific sheet name because my Excel macro is used in france as wel and the default worksheet name there is not "Sheet1". It will help if someone knows if there is a property somewhere sayin what is the default worksheet name. Thanks -- Ana ----------------------------------------------------------------------- Anat's Profile: http://www.excelforum.com/member.php...fo&userid=1670 View this thread: http://www.excelforum.com/showthread.php?threadid=31912 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing "Sheet1"
Hi Anat
Open a new workbook and change the sheet names in it. Save it as a template in the template folder. FileNew click on the file in the taskpane under templates to open -- Regards Ron de Bruin http://www.rondebruin.nl "Anat" wrote in message ... Hi, When creating a new workbook, how do I remove or hide the default worksheet ("Sheet1") after creating my worksheets? I do not want to use the specific sheet name because my Excel macro is used in france as well and the default worksheet name there is not "Sheet1". It will help if someone knows if there is a property somewhere saying what is the default worksheet name. Thanks. -- Anat ------------------------------------------------------------------------ Anat's Profile: http://www.excelforum.com/member.php...o&userid=16706 View this thread: http://www.excelforum.com/showthread...hreadid=319127 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing "Sheet1"
What is a default worksheet? Sheet1 is just a name given to the first index
in the worksheets collection. Could you use Worksheets(1)? -- HTH RP (remove nothere from the email address if mailing direct) "Anat" wrote in message ... Hi, When creating a new workbook, how do I remove or hide the default worksheet ("Sheet1") after creating my worksheets? I do not want to use the specific sheet name because my Excel macro is used in france as well and the default worksheet name there is not "Sheet1". It will help if someone knows if there is a property somewhere saying what is the default worksheet name. Thanks. -- Anat ------------------------------------------------------------------------ Anat's Profile: http://www.excelforum.com/member.php...o&userid=16706 View this thread: http://www.excelforum.com/showthread...hreadid=319127 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1 | Excel Worksheet Functions | |||
How do I color code the "SHEET1" Tab in Excel? | Excel Worksheet Functions | |||
How do I show Auto-Filter "Search" Criteria on Sheet1? | Excel Programming | |||
Sheet1 object not Worksheets("Sheet1") | Excel Programming |