times of opened
 

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

--
jinvicto
-----------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...fo&userid=3409
View this thread: http://www.excelforum.com/showthread.php?threadid=55305

times of opened
 

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" wrote
in message ...

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

times of opened
 

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