How do I hide/password protect a function?

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

Thread: How do I hide/password protect a function?

  1. #1
    New Member
    Join Date
    Jan 2003
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I've created an elaborate function in excel. I would like to do 2 things.

    1. Password protect/hide the code
    2. It uses an array setup in an excel spreadsheet - hide that information too.

    I would still like everyone to be able to use it, just not modify. Any ideas? thank you in advance.

  2. #2
    Board Regular
    Join Date
    Jan 2003
    Location
    Wylie, Texas
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To protect/hide the formula(s), right click on the cell or group of cell and select Format Cells. Click the Protection Tab and make sure that the "Locked" and "Hidden" boxes are selected and Click OK. Then go to Tool, Protection, Protect Sheet and enter a password. You must enter it twice. To protect the spreadsheet where the array is, go to Format, Sheet, and select Hide. Then go back to Tools, Protection, Protect Workbook and enter a password. That should do it unless I over simplified your question.

    Mike Collins

  3. #3
    New Member
    Join Date
    Jan 2003
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks Mike. I didn't think it was that easy. Now all my hard work is locked up tight!

    Greg

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