Hi Justin,
There is an event that triggers whnever a sheet opens. It is called
worksheet_activate. You should put any code(routine) you want in there.

If you want Excel to create an email message for you all you have to do is
use the Macro recorder to record this! Start your macro recorder and then go
to your File menu then click on the "Send To..." item on the menu. Then click
on the "Send with attachment" item that pops up after. Your macro recorder
will have recorded the basis for your code!!

Let me know how that goes.
Please rate this answer!

Aran



--
It wasnt Jesus it was just a fella!
God Bless America!


" wrote:

Thanks for your help. After looking into this a little more I've
decided that instead of converting the worksheet to a PDF and then e-
mailing it I would like to just send an e-mail alert to 2 e-mail
receipients notifing them that they need to take action. If Cell B33 =
Yes then send an e-mail alert saying "Please check your work area for
problems". I would also like the macro to run when the spreadsheet is
first opened, this way I can make it a scheduled task and have it
automatically run everyday at 8am. I have a few other spreadsheets
that work like this however I did not create them. The employee who
created these sheets is no longer with the company and I am now
responsible. I have never done anything like this before and I would
appreciate any help getting started with this. Thanks again for your
help.