Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to be able to count the no. of times a sprdsheet is opened
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to be able to count the no. of times a sprdsheet is opened
For this to work, macros must be enabled. If the user elects not to run
macros (when the security level allows the user to choose whether to run macros), then the counter won't get bumped. Also, the counter could be in the actual workbook, if desired. It could be an unnoticed cell in a hidden row or column, in a hidden sheet, or a named value (Insert - Name - Define) which the macro could modify. The font color could be white, making it invisible. The code should keep two of these counters. If they don't agree, it's likely that a user has found one and changed it. Let the games begin. The VBA project could be locked to keep users from seeing what the code does. Tools - VBA project properties - Protection tab - Lock project for viewing. This is said to be more secure than Excel's passwords for stuff like opening the file, protecting worksheets and workbooks, etc. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Jason Lepack" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count # of times a value is in another spreadsheet | Excel Discussion (Misc queries) | |||
I would like to count the # of times a value occurs in Col B base | Excel Worksheet Functions | |||
how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
How do I count the # of times a value reoccurs and plot it over ti | Charts and Charting in Excel | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) |