delete a row
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
.
|