Hiding text from specific users

[jonathan7272]

Is there a way to hide text in a cell so that only a specific user can view it when they open the workbook?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I was thinking of something that checked the application.username property in VBA, but couldn't work out how to then hide the text.<o></o>
<o></o>
Any suggestions would be appreciated.

 

[jonathan7272]

Oh...I'm using Excel 2000 btw

 

[lenze]

Hi and welcome to the board!!! You can change the font to the background color so it will not be seen on the sheet (But will be in the formula bar, so you need to hide the cell under Format>Protection and protect the sheet). This is not real secure!!!!

The real question is, however, is "What are you really trying to do?"

lenze