What you do is select all cells in the sheet (use the header cell in the top left) Right-click and select "Format Cells" On the Protection tab, make sure "locked" is selected hit OK.
Now go through and select the cells you want available for editing,right-click>Format Cells. and REMOVE the checkbox from the Locked selection on the Protection tab. Now, for this to take affect, you need to protect the document. You don't NEED to set a password, but I would recommend it. (make it something you'll remember!) let me know if you need more assistance. P ________________________________ From: KothariJewelry.com <cont...@kotharijewelry.com> To: excel-macros@googlegroups.com Sent: Thu, June 24, 2010 9:49:27 AM Subject: $$Excel-Macros$$ Uneditable Cells Dear All, I want to prepare an excel calculator , in which some cells will have definite values which the customer can't change once they download it from our website, some cells should have the editable option where the customer can enter values according to his requirements. So can someone explain me how to make uneditable/editable cells in a single excel sheet. Regards Niraj -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
