Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 89
Default Automatic notifications of changes?

Is ther any method of receiving an automatic e-mail notification whenever a
spreadsheet is modified?

I am setting up an error logbook and would like to get an automatic
notification whenever anyone reports an incident.

thanks

Iriemon
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,722
Default Automatic notifications of changes?

Yes.

You could probably invoke an instance of the Worksheet_Change event (google
search for more info), and combine it with some of the coding from Ron's site:
http://www.rondebruin.nl/mail/folder3/smallmessage.htm

Note that what you are asking does require a basic level of understanding of
VBA/macros.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Iriemon" wrote:

Is ther any method of receiving an automatic e-mail notification whenever a
spreadsheet is modified?

I am setting up an error logbook and would like to get an automatic
notification whenever anyone reports an incident.

thanks

Iriemon

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Notifications in Excel Mike Busch[_2_] Excel Discussion (Misc queries) 1 April 11th 08 03:06 PM
Sending notifications through outlook Doberman Excel Discussion (Misc queries) 2 May 6th 07 04:26 PM
reminder notifications in a column L Mieth Excel Discussion (Misc queries) 6 June 10th 05 11:00 AM
Suspense Notifications Tricky Excel Discussion (Misc queries) 1 January 13th 05 01:27 AM
Notifications in Excel? cpme Excel Worksheet Functions 4 January 4th 05 04:45 PM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"