Prev: Way do do search/replace on beginning/end of cell w/o functions?
Next: find all instances of a search item and put result in a single cel
From: Mathieu936 on 22 Mar 2010 17:18
Hi!

I have a worksheet containing many formulas. This worksheet is locked
without any password.

Is there a way to see if somebody unlocked the worksheet to change
formulas?

I want the user can unlock and lock back the worksheet, but I need a
way to know it.

Thanks!
From: H�ctor Miguel on 23 Mar 2010 02:27
hi, Mathieu !

> I have a worksheet containing many formulas. This worksheet is locked without any password.
> Is there a way to see if somebody unlocked the worksheet to change formulas?
> I want the user can unlock and lock back the worksheet, but I need a way to know it.

ActiveSheet.ProtectContents returns true/false according actual protection of active sheet (i.e.)

MsgBox "Active sheet is " & IIf(ActiveSheet.ProtectContents, "", "UN-") & "Protected"

question is: how/when/where/... do you plan to lock-back when the case is ?

hth,
hector.


From: Billns on 23 Mar 2010 18:02
On 3/22/2010 2:18 PM, Mathieu936 wrote:
> Hi!
>
> I have a worksheet containing many formulas. This worksheet is locked
> without any password.
>
> Is there a way to see if somebody unlocked the worksheet to change
> formulas?
>
> I want the user can unlock and lock back the worksheet, but I need a
> way to know it.
>
> Thanks!

I suppose you could ask the user...

You must trust him or her if you allow unlocking.

Bill
 | 
Pages: 1
Prev: Way do do search/replace on beginning/end of cell w/o functions?
Next: find all instances of a search item and put result in a single cel