Hiding Information

You could always put your initials in a cell you know won't be used, then change the font to white.

Originally Posted by darkyam

You could always put your initials in a cell you know won't be used, then change the font to white.

But white font color will be seen in selection. I always do so first to check for "hidden" info. I prefer to use formatting.

1. Put your name in cell that will not be used
2. Right Click > Format Cells
3. In Number tab select Custom
4. Within "Type" field type ";;;" w/o quotes
5. Press Ok

This will not be seen in selection

Originally Posted by contaminated

But white font color will be seen in selection. I always do so first to check for "hidden" info. I prefer to use formatting.

1. Put your name in cell that will not be used
2. Right Click > Format Cells
3. In Number tab select Custom
4. Within "Type" field type ";;;" w/o quotes
5. Press Ok

This will not be seen in selection

Don't understand what you mean. With both methods, the cell's actual value will be displayed in the formula bar when you select the cell.

Martin's way seems pretty good.

put a module in with your details then lock the project

right click any tab
view code
insert module
type anything you want enclosed in single quotes
close module then in project explorer on the left(if you cant see it click view/project explorer)
rightt click the module you just inserted
vba project properties
give it a name
under protection
choose lock and a password
close vba editor save workbook

Putting a module in will mean that the users will need to have to enable macros.

Most of these suggestions can be overcome fairly easily, probably the best way would be to create a Custom Document Property

but even if they disable macros its still in there surely?

Yes, but then you get users who may be worried about the warning & won't use the workbook.

Maybe silly, but how about using separate worksheet & hiding it via VeryHidden attribute?!