Automatically Insert Sheet

[Peter]

Is there a way to have excel automatically add a worksheet
to an excel file upon opening? All files i will be
opening will have only one worksheet. Any direction anyone
could give me would be terrific. thanks, peter

 

[Ron de Bruin]

Hi Peter

Try this event in the Thisworkbook module

Private Sub Workbook_Open()
Worksheets.Add.Name = Format(Now, "dd-mm-yy h-mm-ss")
End Sub

It will give the sheet a name(Date/Time)

 

[Peter]

Ron, your advice worked perfectly. thankyou and have a
great weekend. peter

-----Original Message-----
Hi Peter

Try this event in the Thisworkbook module

Private Sub Workbook_Open()
Worksheets.Add.Name = Format(Now, "dd-mm-yy h-mm-ss")
End Sub

It will give the sheet a name(Date/Time)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Peter" <[email protected]> wrote in

message news:[email protected]...