Code.

Nigel Martin · Mar 30th, 2002, 12:11 PM

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 · Mar 30th, 2002, 12:22 PM

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 · Mar 30th, 2002, 01:59 PM

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.

Mar 30th, 2002, 12:22 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 30th, 2002, 12:11 PM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	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 ?

Mar 30th, 2002, 01:59 PM	#3
Fryer Tuck Board Regular Join Date: Mar 2002 Posts: 64	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.