Code.

[Nigel Martin]

Is it possible to hide the code either can put put on each worksheet or macro code ? I have a spreadsheet that contains peoples passwords in the code. Any ideas ?

[Jack in the UK]

Hi --

No code examples as i rearly post codes for getting them ripped apart but ideas you wanted try this:

All codes / moduels can be hidden from view
Password protected, this is hardle perfect as can be carcked by advanced user suggest 7 letters and numbers that will stop the average advanced hacker takes to long

You could als on runniong a code ask for a password to compleate the code else it fails to execute dont see why not.

any help?

[Fryer Tuck]

Hiding in code is a matter of password protecting. The only way (supposedly) to open the coding is with the password.

On a sheet, that is a different story. A simple method is to put the font at the same color as the background. However, if someone selects more than one cell, the font will be visible. Another method is to hide the cell (row or column). The problem with this is that you can still go to the cell and either unhide it, or see the contents in the formula bar. Your best bet is several steps:
Unlock the cells that will not have the password;
Check both the locked and hidden boxes for the cells that will have the password (hidden disallows viewing contents in the formula bar);
Password protect the sheet.