Excel Edit Form
 

Naz,


Yes you can use a worksheet change event to monitor changes. However as to
sending the email. Yes you can send an e-mail assuming an appropriate e-mail
system is functionally installed on that machine (eg.. outlook) You can send
emails directly through excel (entire workbooks not as much control) or
through manipulationg outlook. The disadvantage to manipulation outlook is
that there are several security issues involved and require user input to
send the e-mail. (i would consider looking into the excel mailing code.)
lookup SendMail in vba help.
Ben
--
When you lose your mind, you free your life.


"Naz" wrote:

Hi everyone,

I want to use the built-in Excel form to get some users to make changes to a
spreadsheet. Is it possible that when they make changes to the spreadsheet
via the form those changes can be e-mailed ot someone.
In other words can you use the change event and some sort of code to pick up
what was changed and then e-mail that.
Or are there any other ways to keep track of the changes and get them e-mail
to someone.
--

_______________________
Naz,
London