Count the number of times a worksheet is viewed

[MichaelRLanier]

Is there a simple macro that will show how many times a worksheet (not
workbook) has been viewed? Thanks.

Michael

 

[Don Guillett]

You could use a worksheet_activate event to add a number to a cell each
time.

 

[Alan]

Right click the worksheet tab, select 'View Code', copy and paste this into
the empty window,

Private Sub Worksheet_Activate()
Range("A1") = Range("A1") + 1
End Sub

Change the cell to one that suits you, close the VB window and save the
file,
Regards,
Alan.

 

[MichaelRLanier]

Thanks Don and Alan. You help is much appreciated.