M MichaelRLanier Mar 30, 2009 #1 Is there a simple macro that will show how many times a worksheet (not workbook) has been viewed? Thanks. Michael
Is there a simple macro that will show how many times a worksheet (not workbook) has been viewed? Thanks. Michael
D Don Guillett Mar 30, 2009 #2 You could use a worksheet_activate event to add a number to a cell each time.
A Alan Mar 30, 2009 #3 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.
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.
