$$Excel-Macros$$ Re: Hi My All Friends Urgent
Thanks On Fri, Aug 28, 2009 at 6:54 PM, Aindril De aind...@gmail.com wrote: Hi Amresh, This can be achieved doing the following steps: 1) Select the entire sheet. 2) Right Click on the selected area and select Format Cells. 3) In the format cells dialog box choose the Protection Tab. 4) Click on the Locked and uncheck it. 5) Click OK. 6) Now select the cell that you want to protect. 7) You Can press the Ctrl key and click on the cells if you want to protect multiple cells. 8) Right click on any of the selected cells and choose Format cells. 9) Choose Format Cells. 10) In the Protection Tab, check the Locked. 11) At this stage the selected cells are locked. 12) Now Protect the sheet using a password (You can choose the relevant protection options or keep the defaults as it is). 13) This will ensure that the Locked Cells cannot be modified. Hope this helps. Please let me know if you need any further help. Regards, Andy On Fri, Aug 28, 2009 at 4:10 PM, amresh kumar amreshkushw...@gmail.comwrote: Hi My All Friends, I want Protect select cell in a Sheet.Can u Help Me in Excel, Thanks, Amresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Hi My All Friends Urgent
Hi Amresh, This can be achieved doing the following steps: 1) Select the entire sheet. 2) Right Click on the selected area and select Format Cells. 3) In the format cells dialog box choose the Protection Tab. 4) Click on the Locked and uncheck it. 5) Click OK. 6) Now select the cell that you want to protect. 7) You Can press the Ctrl key and click on the cells if you want to protect multiple cells. 8) Right click on any of the selected cells and choose Format cells. 9) Choose Format Cells. 10) In the Protection Tab, check the Locked. 11) At this stage the selected cells are locked. 12) Now Protect the sheet using a password (You can choose the relevant protection options or keep the defaults as it is). 13) This will ensure that the Locked Cells cannot be modified. Hope this helps. Please let me know if you need any further help. Regards, Andy On Fri, Aug 28, 2009 at 4:10 PM, amresh kumar amreshkushw...@gmail.comwrote: Hi My All Friends, I want Protect select cell in a Sheet.Can u Help Me in Excel, Thanks, Amresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
