Count the number of times a worksheet is viewed

M

MichaelRLanier

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

Michael
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top