Which of the two of John's methods did you use?
If the worksheet_change event code, did you paste the code into a worksheet
module as instructed?
Did you test to see if it worked?
Did you save the workbook after testing OK?
If the macro on a button code, did you paste the code into a general module?
How are you calling the macro?
Did you test to see if it worked?
Are the recipents enabling macros when they open your workbook?
Gord Dibben MS Excel MVP
On Mon, 17 Mar 2008 13:35:00 -0700, Rodrigo
wrote:
Is their a way to send a spreedsheet with a macro rule trought email. The one
i am cunsorne with is the time stamp macro, provided by McGimpsey in the link
below. I figured out how to use it but know i am trying to send it to some
customers but the formula does not work. The formula is still in the code
tab, but i guess it does not work.
Any suggestions.
http://www.mcgimpsey.com/excel/timestamp.html