View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default A macro that counts the number of times a file is opened

Just a caution - if a user has macros disabled (Excel's default), your macro
will not run

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

wrote in message
ups.com...
Can a macro be written that will count the number of times a file has
been opened? If so, can the count be shown in a designated cell such
as A1. And would the count be affected if the file is saved under a
different name? If you know how to write such a macro, its formulation
would be much appreciated. Thanks.