date row last modified - debug

[alex]

I'm a real nubie with this macro stuff. I googled for a macro and the
below one does exactly what I want but I need help running/debuging
it.

I've read enough Excel 2003 documentation that I need to reference it
from Sub Workbook_Open() .... what I'm missing is how the two
arguments are passed to the sub.

Could I get help debugging and adding to Workbook_Open()

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Puts the date & time in column K when the data changes,
'in the rows in columns A-J
'put in worksheet code
If Target.Count > 1 Then Exit Sub
Select Case Target.Column

'columns to check for data change
Case 1 To 10

'where the time is put
Cells(Target.Row, 11) = Now()

End Select
End Sub


(found at: http://groups.google.com/groups?hl=...%24qP86CHA.3332%40TK2MSFTNGP11.phx.gbl&rnum=1
)

 

[Frank Kabel]

Hi
just put this code in your worksheet module (not a standard module).
The parameters are passed automatically by Excel.

 

[alex]

Hi,

That's what I think I did but.....it's not working....
....can you check this screen shot and tell me if /what is incorrect?

http://www.geocities.com/apolloni/excel-macro.JPG

also the xls file.
http://www.geocities.com/apolloni/Book1-temp.xls

Thanks,
-Alex

 

[Frank Kabel]

Hi Alex
you put your code in the workBOOK module. It has to go in the correct
workSHEET module!

 

[alex]

Ahhh, I see what you mean now. This is great, it works!
Thanks very much.
Regards,
Alex