I am working in Excel 2000 and want

[Bewafaa]

I am working in Excel 2000 and want to do two things:
a) Is there any way of clicking on a date field and automating an email reminder
b) I have a spreadsheet of over hundred rows and eleven coloumns. I have created a macro whereby it copies a row to a new sheet and then uses File, Send To, Mail recipient. To send to a user as a reminder. However I have had to create a macro per row. I wants to know if there is a way to create one macro which I can run on any row.

I am thinking perhaps using VBA would allow me to do this. Please advise of a recorded and written Macro.

Many thanks in advance

 

[xlbo]

Befwaa - this is not a resource for people to provide you with fully written code. If you have a specific problem, people here can help you solve it but you must be willing to try things out / research for yourself as well.
If you post your current macro, I'm sure myself or one of the other residents here will be able to suggest ways to make it usable for all your rows instead of just one

Top tip to start with - instead of hardcoding the row reference, you can use
Selection.row
to determine which row is currently selected...

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes