Re: $$Excel-Macros$$ Hide & lock a formula in the cell

2017-05-07 Thread Puneet Jain
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? E

Re: $$Excel-Macros$$ Hide & lock a formula in the cell

2017-05-01 Thread Paul Schreiner
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"

$$Excel-Macros$$ Hide & lock a formula in the cell

2017-04-30 Thread Puneet Jain
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 Phone(O)-011-23456613 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna