hi! i want to have certain worksheets made when i open a workbook. how do you
write in the code in the Workbook_Open() sub that you want to create a new
worksheet? I just want to create a new worksheet that has a certain
name,nothing else. help please!

Hi April;

This works fine for me...

Sub Workbook_Open()

ActiveWorkbook.Sheets.Add
ActiveSheet.Name = "CallItThis"

End Sub

Just use the Before/After additions to the ActiveWorkbook.Sheets.Add command
(it'll prompt you if you add a space after the "Add" part) to position your
new sheet where you need to, if this is a requirement - as it stands, it'll
just place it in front of whichever sheet was active when the book was opened.

HTH
DS


"april27" wrote:

hi! i want to have certain worksheets made when i open a workbook. how do you
write in the code in the Workbook_Open() sub that you want to create a new
worksheet? I just want to create a new worksheet that has a certain
name,nothing else. help please!