Posted to microsoft.public.excel.misc
|
|
Stop Changes
Hi.
No need Sandy. I think I've got it now. Thanks for everything.
--
vze2mss6
"Sandy Mann" wrote:
Next issue: if somebody wants to change a cell all they have to do is
click
on unprotect worksheet. Am I correct?
I don't really understand what you mean by that.
As your code stands all they have to do is unprotect the sheet then change
the cell. You could add a password to the sheet protection but then all
they would have to do is look at the code to get the password.
There is nothingin Excel that you can do that a determined person cannot
undo.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"joesf16" wrote in message
...
Hi.
Thanks to Sandy and Gord
It works!
Next issue: if somebody wants to change a cell all they have to do is
click
on unprotect worksheet. Am I correct?
Is there any way to prevent this?
--
vze2mss6
"Gord Dibben" wrote:
I see that now Sandy.
Too quick on the trigger.
Removal as you have shown is best.
Gord
On Mon, 20 Aug 2007 22:37:25 +0100, "Sandy Mann"
wrote:
Interesting that you should suggest that Gord,
If Intersect(Range("A:IV"), Target) Is Nothing
where else could it be?
|