Cell Highlight - data avoidance

[potowner]

I have data in cells formatted as White to make the worksheet appear empty. By using Conditional Formatting, if a user enters the correct password in the A1 cell, the data will change to Black and be viewbable. The problem is that if anyone Highlights the cells (either with a left click of the mouse or shift+arrow key) the data becomes viewable. Is there anyway to avoid this from occurring?

Any assistance would be greatly appreciated.

 

[tusharm]

Duplicate. Consolidate to http://www.mrexcel.com/board/viewtopic.php?topic=20586&forum=2&0