RE: $$Excel-Macros$$ Entered data should be locked
Try this First I Unlocked All Cells of sheet then make It Password Protected with A Space Character : Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range Set cell = Target ActiveSheet.Unprotect " " cell.Locked = True ActiveSheet.Protect End Sub From: 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 : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de muralidhar e Envoyé : lundi 1 août 2011 13:32 À : excel-macros@googlegroups.com Objet : Fwd: $$Excel-Macros$$ Entered data should be locked 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-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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 -- -
Re: $$Excel-Macros$$ Entered data should be locked
Hi Muralidhar Try : 1.First select all cells (Ctrl + A) on worksheet 2.Right Click & Go to Format cells 3.Select Protection Tab 4.uncheck Locked 5.Right Click on sheet tab & select view code 6.Paste below code Private Sub Worksheet_Change(ByVal Target As Range) Const pw As String = "password" With Me .Unprotect pw Target.Locked = True .Protect pw End With End Sub Thanks Mahesh On Mon, Aug 1, 2011 at 9:53 PM, Daniel wrote: > HI, > > ** ** > > Sometimes, you have no choice. > > ** ** > > Regards. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* muralidhar e > *Envoyé :* lundi 1 août 2011 13:32 > > *À :* excel-macros@googlegroups.com > *Objet :* Fwd: $$Excel-Macros$$ Entered data should be locked > > ** ** > > 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-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. Jo
RE: $$Excel-Macros$$ Entered data should be locked
HI, Sometimes, you have no choice. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de muralidhar e Envoyé : lundi 1 août 2011 13:32 À : excel-macros@googlegroups.com Objet : Fwd: $$Excel-Macros$$ Entered data should be locked 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-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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 -- -- 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
RE: $$Excel-Macros$$ Entered data should be locked
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
