MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hit Counter

Posted by Bob Moore on December 04, 2001 9:16 AM

I have an Excel spreadsheet saved in HTML format which is the "home page" to an application residing on our NT Network. It's an index with links to other files. I would like to put a hit counter on it in order to track it's usage.

Posted by Mike on December 04, 2001 9:48 AM

Not sure about it being in HTML format, but a simple counter would be:

Private Sub Worksheet_Activate()

Dim count
Set WB = ActiveWorkbook
count = Worksheets("Sheet1").Cells(1, 5)
count = count + 1
Worksheets("Sheet1").Cells(1, 5) = count

End Sub