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
|