D
Dan
Is there a way that when i open an excel spreadsheet that
it will delete the first row automatically
it will delete the first row automatically
T
Tom Ogilvy
Public Sub Aut
pen()
ActiveSheet.Rows(1).Delete
End sub
pen()ActiveSheet.Rows(1).Delete
End sub
D
Dan
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?
where do i put this code in how do i get to the code?
T
Tom Ogilvy
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.
activeproject (should be highlighted in the project explorer),
Insert=>Module from the menu (in the vBE). Put the code in the module.