Hide & keep secret column content

[VitoBdG]

Hi,

I have an issue regarding blocking data in my spreadsheet.

I would like i.e. Column E to be hidden and so no other user could find out what is in there.
I have some contract value details and I would not want others to see it, though after they fill in some other data I'd like to unblock and unfilter.

I mean. I know how to hide it and make user unable to go into this cell. But whenever I block it and type in any other place =E3 it shows up the content.

Any solutions to this challange?
And yes I have been looking for a solution, could not get it

~Vito

[:) Sixthsense :)]

And yes I have been looking for a solution, could not get it

Yes, there is no solution for your issue since it can be easily cracked using = and the Workbook|Worksheet|Cell Refernce from any of the other Workbook|Worksheet

[VitoBdG]

What's your opinion on this one then?

I hate to hear something can't be done.

I could think of creating like a Unique ID and after they fill in columns I'd VLookup all the rows to the contract details.

But this is not the perfect solution.

[Richard Buttrey]

Hi,

With the Worksheet_SelectionChange event (or perhaps better still in the Workbook_SheetSelectionChange event if you want this check to exist everywhere.

Please Login or Register  to view this content.

[:) Sixthsense :)]

Excel is not designed for high level of protection, which is clearly intimated by Microsoft

[VitoBdG]

Hi,

With the Worksheet_SelectionChange event (or perhaps better still in the Workbook_SheetSelectionChange event if you want this check to exist everywhere.

Select Code copy to clipboard
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Formula Like "=E*" Then
Target = ""
End If

End Sub

you seem to be Geek!

I'll try in few hrs, might be a solution