rom: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: Monday, August 01, 2011 9:54 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Entered data should be locked
HI,
Sometimes, you have no choice.
Regards.
Daniel
De : ex
>
> ** **
>
> Hello friend,
>
>
>
> Thank you but i need without macros is it possible to do this it is more
> helpful to me.
>
> Regards,
>
>
>
> Muralidhar E.
>
> -- Forwarded message --
> From: *Danie
Hello friend,
Thank you but i need without macros is it possible to do this it is more
helpful to me.
Regards,
Muralidhar E.
-- Forwarded message --
From: Daniel
Date: Sun, Jul 31, 2011 at 8:44 PM
Subject: RE: $$Excel-Macros$$ Entered data should be locked
To: excel
Hello,
I protected the sheet (password : excel). In the sheet module I put the
macro :
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
ActiveSheet.Unprotect "excel"
For Each c In Target
If c <> "" Then c.Locked = True
Next c
ActiveSheet.P
