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.Protect "excel"
End Sub
Have a look at the attached workbook.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de muralidhar e
Envoyé : dimanche 31 juillet 2011 14:25
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Entered data should be locked
Dear Friends,
If any one can helped can be appreciated i have data like frequently
repeated data so i would like to lock the entered data and it should not be
modified i.e. my file should allow empty cells should be entered, if any
correction or modification needed that should ask the password.If the help
is without macro is better to me.
--
Thanks & Regards,
Muralidhar E.
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
lock entered data.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
