Re: autolock a cell after entering value into it

From: dean collins (collins_dean'spam-me-here'_at_hotmail.com)
Date: 02/15/04 

Date: Sun, 15 Feb 2004 11:42:56 +1100

Harlan,
Can you provide more information about hwo you would do this via email? I
have something siilar and this sounded like a good idea until you mentioned
mistakes.

What would you suggest.

Cheers,
Dean

"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:o2uXb.3252$_4.269@www.newsranger.com...
> "Paul B" <newspab@surfbest.net> wrote...
> >Deepak, ths will protect the cell after input, put in work*** code and
> >unlock all cells in the range first.
> >Ypu will also need to protect your VBA project so no one can see the
> >password in it,
> ...
> >Private Sub Worksheet_Change(ByVal Target As Range)
> >'Automatically Protecting After Input
> >'unlock all cells in the range first
> ...
>
> This is a pood design. Humans have been known from time to time to make
> mistakes, like typos. Using a change macro to protect cells upon entry is
> very likely to cause frequent problems.
>
> Next, if users are clever enough to look in VBA modules to find passwords,
> they're likely smart enough to search newsgroups to find out how to
disable
> passwords. EXCEL DOES NOT PROVIDE TRUE SECURITY! Relying on it to do so is
> foolish. Excel provides only lightweight idiot-proofing.
>
> Anyway, the ideal method of 'freezing' attendance entries would be to have
> the BeforeClose event handler e-mail the current workday's attendance
***
> to a central source. This assumes the machine on which this workbook
resides
> has an e-mail connection and that the file would be opened and closed each
> workday. If not, more details about how the file would be used and how the
> machine that would run it was configured would be useful.
>
>