Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel worksheet (2003)

    Anyone know how to keep a worksheet listed in the tabs but prevent anyone without a password from seeing the data?

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheet (2003)

    There is no foolproof way of doing this. Excel is not very secure, and it's password protections are fairly easy to crack by anyone with access to the internet. Therefore, if the data is really propriatery, and the people you are hiding it from are determined, anything you do in Excel can be broken into.

    The best way I can think of to do this would be something like the following:

    1- Select all of the cells on the sheet, and change the background and font colors to the same color. This should make anything in the cells invisible.

    2- Protect the worksheet with a password with all of the cells locked (that is the default).

    3- Write VBA code that will ask look to see if the sheet is currently visible or invisible. If the sheet is invible, then ask the user for a password. If the correct password is entered, unprotect the sheet, change the font color to something that will make it visible and then reprotect the sheet (if you don't want the user changing data on it). If the sheet is currently visible, then unprotect, change the font color to the background color, and reprotect the sheet.

    4- Protect the VBA project so the user can't see what is being done.

    5- Attach the VBA code to a button somewhere in the workbook if desired.

    Remember, any determined user can defeat the above.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Aug 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheet (2003)

    Thanks so much for your suggestions, and your warning.

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel worksheet (2003)

    I don't think that the user needs to be terribly determined. If they inadvertently highlight the cells, the data is exposed.
    Regards
    Don

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel worksheet (2003)

    Edited by author; item 3 added to the list.

    I would be inclined to:

    1. <LI>Place the sensitive data on a sheet that is very hidden
      <LI>Place an empty sheet with the appropriate tab with the visible sheets.
      <LI>Create a command bar on opening the file
      <LI>Run a macro from the command bar
    The macro would then capture the data from the hidden sheet. You could either build a timer into the macro to leave it exposed for a finite period, or have an Auto_Close macro to hide it on closing the file.
    Regards
    Don

Posting Permissions

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