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 <dcolarde...@free.fr>
Date: Sun, Jul 31, 2011 at 8:44 PM
Subject: RE: $$Excel-Macros$$ Entered data should be locked
To: excel-macros@googlegroups.com
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
--
*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
lock entered data.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
