Counter
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
--
Regards
Frank Kabel
Frankfurt, Germany
donny wrote:
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
|