Workbook access counter in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to add a counter to an Excel sheet that adds one every time
the file is accessed? Similar to a webpage counter I suppose is what I am
after.
 
Place this in ThisWorkbook-module:

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1") = Worksheets("Sheet1").Range("A1") + 1
ThisWorkbook.Save
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to hide password? 1
1+2+3+4+........... Counter 3
Excel Macro (open and save files with different drives) 1
Hit counter 4
Excel 2007 named ranges - how to use as function parameter? 3
Complex Counter 1
code help 0
multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)" 3

Back
Top