Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

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

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    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?

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •