Automatically Insert Sheet

P

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
 
R

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)
 
Top