Hide formula without password protecting sheet

To consider all the cells in worksheet
Try changing

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

@haripopuri


Hi

Thanks for you Replay

as per your instruction i changed the range mode then what happen you know when i enter any matter then it will not appear and when i remove the value from cell then it is not delete i mean

say i use the formula in B1 as

Please Login or Register  to view this content.

WHEN I SELECT THE B1 IT WILL HIDE THE FORMULA AND DISPLAY THE RESULT IF I WOULD LIKE TO CHANGE OR EDIT THE NUMBER THEN IT IS NOT ACCEPT AND IF I ENTER ANY NUMBER OR WORD IN ANOTHER CELL THEN ALSO IT IS NOT APPEAR

KINDLY HELP

Thanks


SP

Hi,

That's what exactly I got when i tried the code given by you. You have mentioned that this code is working fine except the range, hence I suggested how to change range. Otherwise this code doesn't make sense for what you wanted.

Can you please explain what would you like your code to do?

@Haripopuri

Hi

i am sorry for my late replay

Actually the Code functions for FORMULA hide and shows the value of the formula in Formula bar with out protecting with in the specific range if some one press the F2 or Edit the cell then it's display the Value only not the formula but the formula is there in that cell, when we insert the row in given range then the last row of formula is displayed in formula bar due to range is changed in the code suppose the range is (A1:A20) if some one insert a new row in A10 then the formula of A21 is Displayed in the Formula Bar

so i want to change the code / remove the range section, if any cell has formula then it will show only the value not formula in the worksheet if some one insert the row then no problem because there is no restriction for Range

Hope you Under Stand

Thanks

SP

Hi

Is it possible for me

Thanks

SP

HI

Still i stuck here

Kindly Help

Thanks

SP

Hi SP,

I am sorry, I was travelling. I am not aware of any code for this purpose. If your existing code is not working then you are on your own.