View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jason Lepack Jason Lepack is offline
external usenet poster
 
Posts: 120
Default I need to be able to count the no. of times a sprdsheet is opened

Create a new workbook that is hidden in the same directory. Now in the
original spreadsheet create a macro that will run in the
"workbook_open" method that adds 1 to cell A1 in the hidden workbook.

Cheers,
Jason Lepack
Melvin P wrote:
I have a spreadsheet on a common drive accessed by workmates. I need a simple
counter to tell me how many times the sheet is opened. Any assistance is
appreciated.
Cheers