Re: autolock a cell after entering value into it

From: Harlan Grove (hrlngrv_at_aol.com)
Date: 02/15/04 

Date: Sun, 15 Feb 2004 05:23:38 GMT

"dean collins" <collins_dean'spam-me-here'@hotmail.com> wrote...
>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.

There are threads in the Google Groups archives that deal with e-mailing
individual worksheets. Just add logic to select the current day's worksheet,
and put the whole thing in the workbook's BeforeClose event handler.

Not necessarily a good example, but see

http://groups.google.com/groups?threadm=851b01c3e92a%24cd166100%24a501280a%40phx.gbl