Removing "Sheet1"

  • Thread starter Thread starter Anat
  • Start date Start date
A

Anat

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
 
Hi Anat

Open a new workbook and change the sheet names in it.
Save it as a template in the template folder.

File>New
click on the file in the taskpane under templates to open
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill in data that is not empty 1
Excel VBA help: Text file formatting 19
Copying cells and formula from closed workbook to all sheets in open workbook 0
Workbook jumps to Sheet1, cell A1, regardless of where it was whenlast saved 3
Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved 2
Embed information in Worksheet for error checking 0
Possible to refer to a sheet's object name ? 10
Cell values to an array, then array transpose to another workbook 8

Back
Top