Ready-made named sheets

**refp16** · 09-06-2006, 11:32 AM

Hello.

My problem is the following:

SOMETIMES I am in the need of opening a blank Excel file that has ready-named sheets.

I want to be able to automatically name five (5) sheets in my recently opened file as follows:

sheet 1: inpTrData
sheet 2: desTrData
sheet 3: inpValData
sheet 4: desValData
sheet 5: inpTestData

Please remember that I want to do this ocassionally and not every time I launch Excel.

How can I achieve this?

THANKS IN ADVANCE.

**refp16** · 09-06-2006, 12:29 PM

Figured out myself one way:

Simply RECORD a Macro.

**Bearacade** · 09-06-2006, 12:32 PM

You could use a macro:

Sub SheetSetUp()
Sheets("Sheet1").Name = "inpTrData"
Sheets("Sheet2").Name = "desTrData"
Sheets("Sheet3").Name = "inpValData"
Sheets("Sheet4").Name = "desValData"
Sheets("Sheet5").Name = "inpTestData"
End Sub

You can export the module and load it up for each new workbook you need it, or you can just copy and paste this every time you need it...

**Chappo** · 09-06-2006, 01:08 PM

Or... the most simple way I can think of is save a template with the named sheets on it and when you want a sheet like that, open up your template and then save it under a different name when your finished.