Thread: Counter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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