How do I set up a counter on my Excel workbook?

[Audiojoe]

Hey, I need to set up a counter on my Excel workbook that will display how many people have opened it like on a web-page. I need to display it in Cell F10 in a sheet called "DXF"

Can anyone help?

[Russell Hauf]

On 2002-02-21 08:46, Audiojoe wrote:

Hey, I need to set up a counter on my Excel workbook that will display how many people have opened it like on a web-page. I need to display it in Cell F10 in a sheet called "DXF"

Can anyone help?

Well, as long as you don't care about people who open it read-only, you could put code in the Workbook_Open event. Something like:

Worksheets("DXF").Range("F10") = Worksheets("DXF").Range("F10") + 1

Hope this helps,

Russell