tally the number of work

[reylan]

Is this possible to record in sheet 1 the number of times they open the workbook let us say cell A1 when the workbook is open it will tally as 1 and then next time they open it will add 1 and I put a password too "diesel" in sheet 1 so that i cannot cheat the number of times I visited this workbook Control.

 

[jeffreybrown]

Hi reylan,

Where did you place the code? This code should be pasted in the ThisWorkbook module.

And for what it is worth, I would go with a cleaner code such as Smitty. His use of variables and setting them once so they can easily be used later.

 

[reylan]

I can't find the workbook module can you lead me to that please.

 

[Smitty]

In the VBE, look in the Project Explorer and expand your project-->Expand Microsoft Excel Objects. ThisWorkbook should be at the bottom of the list.