Code.

Nigel Martin

Board Regular
Joined
Feb 17, 2002
Messages
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 ?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top