JUBOR,
If you need the formula hidden and not a locked cell, you can just unlock the cells and check the hidden box, and then protect the worksheet. As for the formula bar, here is the code:
Sub ToggleFormulaBar()
' This code Toggles the Formula Bar. Or you can put either "= False" or "= True"
Application.DisplayFormulaBar = Not Application.DisplayFormulaBar
End Sub
Ryan,
i copy the code but it's not working..could u explain it more detail..i mean
about the code and how to display it.i'm just a beginner.hope you don't mind
thanks
If you need the formula hidden and not a locked cell, you can just unlock the cells and check the hidden box, and then protect the worksheet. As for the formula bar, here is the code:
You need to put the code into a module window for the workbook you are working in or put it in your "PERSONAL.xls" workbook. The code that I gave you will display the formula bar if it's gone or take it away if it's there. Put the cursor anywhere within this code and hit F5 to run the code. Don't know what else to say, hope this helps.
Ryan