maybe you type too quickly...
the macro is one worksheet and the the macro is opening anotehr macro
If you display the cells format dialog you will see on the Protection tab you can have the contents of the cell Hidden. This will stop the formula displaying in the formula bar.
Once you have set the Hidden property you need to protect the worksheet.
And if you want you can then protect the workbook, but that will have no effect until the workbook is closed and reopened.
With ActiveSheet
With Range("B5")
.Locked = True
.FormulaHidden = True
End With
.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="carrot"
End With
Bookmarks