Is it possible to hide formula without protect sheet feature in excel

Is there anyway(vba codes) to hide formula without protecting sheet?

The only way that I can think of is to use VBA to prevent selection of a cell with a formula. You would use the Worksheet_SelectionChange sub for that worksheet, and check for either specific cells you are concerned about, or any cell with a formula. If the cell is selected, the code will select a different cell. You would also want to turn off the Formula Bar because the formula will be visible for a fraction of a second on selection, but the user can just turn it back on again.

Also note that this method does not provide security because it won't work if a user does not enable VBA for the file.

but with your code,i cannot copy or paste in between the cells that has formula. i have formula from O2:O & lrow so i need to hide it.If i use hide n lock features it doesn't work properly.

This is the code i m using.

Please Login or Register  to view this content.

@KrishnaR

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

However, if you continue to not use code tags, you can expect to have your thread BLOCKED until you add them yourself.

Originally Posted by KrishnaR

but with your code,i cannot copy or paste in between the cells that has formula.....

This is the code i m using.

I don't see how this code relates to "cannot copy or paste in between the cells". That code puts formulas in blank cells, it does not copy or paste anything. And it should not interact with the code I gave you since you turn off events to do it.

You are adding requirements that you did not include in your first post. I answered just what you gave us to start with.

Please provide a sample file and explain everything you need to do.

Originally Posted by KrishnaR

i need to hide my formula mentioned in the code,i dnt want formula to be shown even when i click on those respective cells.

Sheet protection is the only to be able to click on a cell with a formula and hide the formula.