Dear Mr. Paul Thanks for the response.
Need one more help..... I have 2 worksheet in one file and both are linked to each other. I did the same as explained by you and was successful. Now for the second worksheet, if i need to lock only one coloum and unlock the second coloum, is it possible? EX - First Coloum indicates the project name, address - this coloum need to be locked to avoid any changes Second Coloum indicates option to be filled by the client like project size, cost etc (variable item) Please Help. On Mon, May 1, 2017 at 7:23 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > The steps would be: > 1) Select all cells > Right-Click and select "Format Cells" > go to "Protection" tab and make sure "Locked" is selected. > Select "OK" > 2) Select all cells you want to be able to select/change > Right-click and select "Format Cells" > on "Protection" tab, DE-SELECT the "Locked" checkbox. > select "OK" > 3) Select "Protect Sheet" on Review tab. > Remove the checkbox that allows locked cells to be selected > But LEAVE the check for selecting UNLOCKED cells. > You can add a password or not (for testing, you can leave the password > off) > > Note: > Locked/Unlocked and Hidden/Unhidden only is enabled when the sheet is > protected. > otherwise, all cells are unlocked and shown. > > hope this helps. > ----------------------------------------- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------------------------------- > > > On Monday, May 1, 2017 2:20 AM, Puneet Jain <puneet...@gmail.com> wrote: > > > Dear All > > I request you to please help me in Excel sheet that how to hide & lock a > formula in the cell, in the same way as done in Income tax excel form > > -- > With Warm Regards > > Puneet Jain > > Mobile-9899068873 <(989)%20906-8873> > Phone(O)-011-23456613 > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- With Warm Regards Puneet Jain Deputy Manager ( Renewable Energy & CDM), Power Finance Corporation Urjanidhi,1,Barakhambha Lane, Connought Place, New Delhi, Mobile-9899068873 Phone(O)-011-23456613 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
