View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bsnapool[_17_] bsnapool[_17_] is offline
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