Is there a way that when i open an excel spreadsheet that
it will delete the first row automatically

Public Sub Auto_Open()
ActiveSheet.Rows(1).Delete
End sub

--
Regards,
Tom Ogilvy


Dan wrote in message
...
Is there a way that when i open an excel spreadsheet that
it will delete the first row automatically

im very good with access but dont know excel that well
where do i put this code in how do i get to the code?
-----Original Message-----
Public Sub Auto_Open()
ActiveSheet.Rows(1).Delete
End sub

--
Regards,
Tom Ogilvy


Dan wrote in message
...
Is there a way that when i open an excel spreadsheet
that
it will delete the first row automatically


.

Alt+F11 gets you to the visual basic editor. With your workbook as the
activeproject (should be highlighted in the project explorer),
Insert=Module from the menu (in the vBE). Put the code in the module.

--
Regards,
Tom Ogilvy


Dan wrote in message
...
im very good with access but dont know excel that well
where do i put this code in how do i get to the code?
-----Original Message-----
Public Sub Auto_Open()
ActiveSheet.Rows(1).Delete
End sub

--
Regards,
Tom Ogilvy


Dan wrote in message
...
Is there a way that when i open an excel spreadsheet
that
it will delete the first row automatically


.