Users can change Password

Hi

Any one help me!

I want to do a form in the excel worbook to allow users to change their password after the first login. by the way the users password login are already created.

finally I want a code to protect the sheet or some cells when the user save the change he made and the other users can view only, and the next day the protect remove automatically.


Thanks

Hello Habib,

These macros will run when the Workbook is opened and is closed. When the user closes the Workbook, he or she will be prompted for a password to protect the Worksheets. This can be done only once. After it has be done, the Worksheets are protected for at least 1 day.

When the Workbook is opened, the macro checks to see if 1 day or more has passed since the Worksheets were protected. If so, all the Worksheets will be unprotected and the user can make changes.

Add a Standard VBA Module to your Workbook and then copy and paste the code into it. Then place calls to the macros in the Workbook events shown in the examples.

Please Login or Register  to view this content.

Calling the Macros:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call LockWorkbook
End Sub

Private Sub Workbook_Open()
Call UnlockWorkbook
End Sub


If you have any questions, please contact me.
Sincerely,
Leith Ross