• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hide formulas

Just a funny way..

* View > Formula bar > Unhide.

* Excel > Option > Advance >
Uncheck "Edit Directly in the cell.."
 
Hi Deb ,

I doubt that your suggestion will prevent viewing of the formulae , which is the basic requirement.

Even though editing is disabled , and the formula bar is disabled , pressing F2 with the cursor in the cell which has the formula , displays the entire formula provided the column width is large enough.

Even without increasing the column width , using the Evaluate Formula feature displays the formula.

Narayan
 
I am sure protecting the sheet is the only way to do what he wants
 
@Pinang

I am not sure It is possible and how much secure about our work

As a blind sot just i tried a code please check

Code: 
Sub Formula_Hide()
With Range("A1")
     .Formula="=Sum(1+1)"
     .Value =.Value
End With
End Sub

Thanks
 
Hi Pinang,

As all above experts saying it can't be done without protecting your sheet.
However you can try sheet protection with no password.
 
You must log in or register to reply here.
Back
Top