how to hide formula bar contents

[legolas]

Hello,

I have a cell J42 which has a formula, i need to hide its contents from the formula bar

is there a code to use , without having to use the "hidden"and sheet lock

i use Excel 2010

thank you

[mehmetcik]

why don't you use a simple sheet specific macro?

all it needs to do is to insert your formula whenever any cell on the sheet is changed, wait for the sheet to recalculate
and replace the formula with its value.

right click on the sheet name at the bottom of excel and select view code.

paste this code.

Please Login or Register  to view this content.

now whenever you do anything on that sheet A1 will show the date.

Try typing over the date and see if you can.

[legolas]

good method but my A1 already contains a formula so it is now showing the date and not the formula result
is there any other way !

thanks

[:) Sixthsense :)]

You would like to hide Formula?

Or

The Result arrived by the formula?

[mehmetcik]

The idea is to use your formula.

If you start the macro recorder

select cell A1, click into the formula bar at the top of excel

and press enter, as if you are entering the code for the first time.

Then stop the macro recorder.

Open visual basic and you will see your formula has been recoded.

replace

Please Login or Register  to view this content.

in my macro with your formula.

[legolas]

@sixthense

my formula is in A1 , when i click A1 i need to keep the formula result but i want the formula to be hidden and not showing in the formula bar

[:) Sixthsense :)]

@sixthense,i want the formula to be hidden and not showing in the formula bar

Check this link to know how to do it

http://www.howtogeek.com/175759/how-...in-excel-2013/

http://www.tech-recipes.com/rx/1682/...m_other_users/

[mehmetcik]

I am unsubscribing from this thread.

If and when you decide you want my help then send me a Private Message.

[legolas]

sorry guys but so far non of the methods is working
i just need a simple formula

thanks