Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

COUNTING

  Asked By: Ricky    Date: Dec 19    Category: MS Office    Views: 596
  

for Excel document, I want to know how many times the document got
opened. My thought is: in one cell, I type 1 into it, next time when
somebody opened this document, it will automatically changed into 2,
etc.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Connie Wallace     Answered On: Dec 19

Have a look at the OnOpen event. You can add one to a cell  when the
workbook is opened  by grabbing that event.

That won't actually count the number of times it's been opened, of course.
But it'll count the number of times it's been opened and saved.

 
Answer #2    Answered By: Adelino Fischer     Answered On: Dec 19

If you wanted to you could add a save to the OnOpen event macro Dave S
suggests.

 
Didn't find what you were looking for? Find more on COUNTING Or get search suggestion and latest updates.




Tagged: