Hide Cell contents
 

Is there any way to hide / protect the contents of a cell so a user cannot
see it at all. I need to enter a file path into a cell (for later use in
another macro). We need to hide the path from users so they can't navigate
to this path.

I have protected the sheet and chaged the font to white but if a user clicks
on it, they can still see it.

Thanks for the help.....
--
JT

Hide Cell contents
 

On 17 apr, 17:18, JT wrote:
Is there any way to hide / protect the contents of a cell so a user cannot
see it at all. I need to enter a file path into a cell (for later use in
another macro). We need to hide the path from users so they can't navigate
to this path.

I have protected the sheet and chaged the font to white but if a user clicks
on it, they can still see it.

Thanks for the help.....
--
JT

Hi JT,

You're almost there. Besides 'Locked' you should also select 'Hidden'
on the 'Protection' tab and when protecting the sheet you should
disallow selecting protected or unprotected cells. Together with
changing the color this does the trick.
Additionally you could make the sheet 'Very Hidden' (using the
properties window in VBA).
But isn't it easier just to define it as a constant in the program? Or
communicating it via the registry?

DQ