Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide the contents of cell | Excel Discussion (Misc queries) | |||
How do I hide the contents of a cell from printing? | Excel Discussion (Misc queries) | |||
Hide Cell Contents. | Excel Discussion (Misc queries) | |||
how can I hide the contents of a cell so others cannot see it | Excel Discussion (Misc queries) | |||
Hide Contents of Calculated Cell | New Users to Excel |