LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro to alert when workbook saved or updated?? Is this possible?


Is there anyway I would be able to know when a worksheet has been
updated by using a macro?

I have 73 files within a folder which are either updated from Monday -
Wednesday (Or sometimes not even updated) by managers.

Is there anyway I could automatically find out whether the files have
been updated and maybe the date of when it was last saved?

Hope this is all the info you may need.

Many thanks

Andrew


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=563912

 
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
automate email alert when excel workbook get updated JMT Excel Worksheet Functions 1 October 15th 08 01:53 AM
audio alert when a shared workbook is saved by any user Bob W Excel Discussion (Misc queries) 4 September 10th 08 02:03 AM
Date last saved/updated Hal Excel Programming 2 May 22nd 06 08:28 PM
Run Macro(save workbook) after cell updated titch New Users to Excel 3 February 5th 06 07:55 PM
How to have:= NOW () date/time change only if updated and saved Bob Provis Excel Worksheet Functions 2 August 7th 05 10:47 AM


All times are GMT +1. The time now is 10:30 AM.

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

About Us

"It's about Microsoft Excel"