Code.
Code.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Code.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com