times of opened

[jinvictor]

how can i know howm many times the workbook had been opened?
say in A1 shows how many times.

[Tom Ogilvy]

Private Sub Workbook_Open()
With Worksheets("Sheet1")
.Range("A1").Value = _
.Range("A1").Value + 1
End With
ThisWorkbook.Save
End Sub


Placed in the thisworkbook module

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"jinvictor" <[email protected]> wrote
in message news:[email protected]...
>
> how can i know howm many times the workbook had been opened?
> say in A1 shows how many times.
>
>
> --
> jinvictor
> ------------------------------------------------------------------------
> jinvictor's Profile:
http://www.excelforum.com/member.php...o&userid=34099
> View this thread: http://www.excelforum.com/showthread...hreadid=553052
>

[Greg Wilson]

See John Walkenbauch's simple method. I suggest keeping it outside of the wb
instead:

http://j-walk.com/ss/excel/tips/tip95.htm

Greg


"jinvictor" wrote:

>
> how can i know howm many times the workbook had been opened?
> say in A1 shows how many times.
>
>
> --
> jinvictor
> ------------------------------------------------------------------------
> jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
> View this thread: http://www.excelforum.com/showthread...hreadid=553052
>
>