Counter

  • Thread starter Thread starter donny
  • Start date Start date
D

donny

Is there a way to count the # of times a particular
spreadsheet has been open? via VBA or other application? I
need to find out if the reports I'm sending out are being
looked at and analyzed, and not just deleted lol. Any help
would be great.

Thanks
 
Hi
one way: Put the following code in your workbook module
Private Sub Workbook_Open()
With Sheets(1).Range("A1")
.Value = .Value + 1
End With
End Sub

this increments cell A1 on your first sheet everytime you open this
workbook
 
This is very good but is there a way to count w/o macros
being enabled?
I don't want the user to have the option of Disabling or
enabling the macro, which will affect the count, and I
don't want to set there security macro to low. Thanks
 
Back
Top