Hi Gord,
This looks great! And now, how can I aviod that the user unprotecs the sheet
himself? (Tools - protection - unprotect sheet)
If I didn't need this spesific macro, I would password-protect the sheet.
How can I do this in the macro when the user need to run the macro several
times. Is there a way for the macro to type the password to open - and then
passwordprotect it again?
thanks,
traima
Gord Dibben skrev:
> When you re-protect the sheet in your macro, protect all cells and make locked
> cells unselectable.
[quoted text clipped - 19 lines]
> >
> >traima
Gord Dibben - 09 Mar 2007 18:05 GMT
traima
With ActiveSheet
.Unprotect Password:="justme"
.Calculate
.Cells.Select
Selection.Locked = True
.EnableSelection = xlUnlockedCells
.Protect Password:="justme"
End With
Note: you might want to lock the project also to prevent users from looking at
the code to get the password.
With your workbook open.
Alt + F11, CTRL + r
Right-click on your workbook/project and "Properties"
Select "Protection" tab and "lock project for viewing".
Enter a password.
Note: workbook must be saved/closed and re-opened before the locking takes
effect.
Gord
>Hi Gord,
>
[quoted text clipped - 34 lines]
>> >
>> >traima