Dear all As per your mail i am unable to find what is the radio buttons. as i m new to excel. can any one suggest the entire procedure regarding these radio buttons and use.
Thanks in advance hope i wil get the reply fast. Regards LKModi On Sun, Jun 27, 2010 at 9:34 PM, ayush jain <jainayus...@gmail.com> wrote: > Hi Niraj, > > I have protected the entire sheet keeping the required cells and radio > buttons unprotected. Hope this helps. > Attached is the sheet for your reference. > > Let us know if any further help is required. > > Thanks and Best regards, > Ayush Jain > > > On Sun, Jun 27, 2010 at 4:11 PM, KothariJewelry.com < > cont...@kotharijewelry.com> wrote: > >> Dear All, >> >> Thanks for the guidance till now. >> >> I am encountering this small problem over the radio buttons getting >> protected which i dont want to. >> >> 1. I want to hide all the formulas on the sheet which i am using so i used >> the protech sheet with hide option. >> 2. I want to provide only B14-B18 and E6 as an editable option so i am >> using protect sheet with lock option. >> >> But, now i am encountering problem over the selction of radio buttons >> also, since they are getting protected the user doesnt have any option to >> select the karat type which he wants to. >> >> Kindlly rectify the sheet mail me >> >> Thanks >> Niraj >> >> On Sat, Jun 26, 2010 at 9:28 PM, ayush jain <jainayus...@gmail.com>wrote: >> >>> Hi Niraj, >>> >>> I have added three radio buttons in row 4 to select the karat type. The >>> value of cell D5 will change as per the radio button selection. Do not >>> delete the value of cell D5. >>> >>> I have also modified the formula in D18 to change value on the basis of >>> selection. >>> Please have a look at file and let us know if you need any further help. >>> >>> Best regards, >>> Ayush Jain >>> Group Manager. >>> >>> >>> On Sat, Jun 26, 2010 at 6:55 PM, KothariJewelry.com < >>> cont...@kotharijewelry.com> wrote: >>> >>>> Dear All, >>>> >>>> I am herewith attaching a excel worksheet. Can someone help to me to >>>> provide a radio button or select option in the sheet which the customer >>>> selects and depending upon the option he selects the final pricing is >>>> displayed for gold coins, >>>> >>>> IF customer selects 24 karat = 1900, then D18=C14*B5 >>>> IF customer selects 22 karat = 1748, then D18=C14*D5 >>>> IF customer selects 18 karat = 1900, then D18=C14*F5 >>>> >>>> Kindly revert >>>> >>>> Thanks >>>> >>>> Niraj >>>> www.kotharijewelry.com >>>> >>>> >>>> >>>> On Thu, Jun 24, 2010 at 10:43 PM, Paul Schreiner < >>>> schreiner_p...@att.net> wrote: >>>> >>>>> 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 >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 >>>> >>> >>> >>> >>> -- >>> Best regards, >>> Ayush Jain >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 >>> >> >> > > > -- > Best regards, > Ayush Jain > > -- > > ---------------------------------------------------------------------------------- > 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
