daily changing password

[patilsshree999]

need a help ...

vba code for daily changing password

like

example no 1 -
the common number is 40 and today's date is 28/08/2012
then password =common number+sum of (today's day+current month)
thats 40+28+8 = 76

and inverts the sum as 67

67 is the password for today

example no 2 -
the common number is 40 and today's date is 29/08/2012
then password is common number+sum of (today's day+current month)
thats 40+29+8 = 77

and inverts the sum as 77

77 is the password for today

[Kyle123]

how about

Please Login or Register  to view this content.

[patilsshree999]

i cant understand kyle123, m basic user for excel

[Kyle123]

I'm not sure VBA really gets any more basic.

It adds todays month (8) to todays date (28) and adds 40

[patilsshree999]

how to add this function to excel for password kyle123

[Kyle123]

What password?

[patilsshree999]

for workbook protection

[Kyle123]

You can't really do this automatically. Since you would need to have the workbook open to run it.

It's nowt very secure anyway since someone could look at your code and see how you create your passwords