How to hide excel formulas?

[VBABEGINER]

Hi All Experts,

Its very normal query..which is not solved. Any body kindly help me.

I made the excel sheet which having no. of calculation.

But now i dont want to display all the formulas.
its easily seen....its problem for me.

is there trick to hide all excel sheet formulas?

I added only one line of coding, but that is not working.

Range("A1:E1000").value = Range("A1:E1000").Value

 

[Ruddles]

When you say you want to hide the formulae, do you mean you want to:-

1. turn them all into hard-coded values so they don't work as formulae any more
2. hide them but have them continue to work as formulae

What's the reason behind this?

 

[VBABEGINER]

Good evening Sir,
Thank you for ur reply.

1. hide them but have them continue to work as formulae

= ok, this mean if i hide the formulas then it wont work?
i dont no this concept.

actually, i did some calculation part, that i dont want to display to my client.
that is y?
so can we do this?

 

[Ruddles]

You can protect the worksheet and not allow the user to select locked cells but if they open it from VBA they will be able to see the formulae in the cells.

You could code some of your more vital formulae in VBA and make them into user-defined functions (UDFs), then protect the VBA project.

Whatever you do, hand the protected workbook over to someone else and ask them to crack it for you as they will probably think of something you forgot to consider.

Remember Excel was never designed as a high-security environment.