Counter

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
 
F

Frank Kabel

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
 
G

Guest

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
 
Top