+ Reply to Thread
Results 1 to 2 of 2

Hide Worksheet in Real-Time Environment for Those Without Password

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Hide Worksheet in Real-Time Environment for Those Without Password

    My company, Company A, will be sharing an excel workbook with Company B. It will exist as a real-time file and will be hosted in the collaborative webspace. The thing is, though, that we can't let company B see "Worksheet 1". That being said, we ourselves need to see it. Is there a way to password protect the file not only from editing, but from viewing? I know at the basic level this is possible, but like I said, we ourselves need to see Worksheet 1. If I hide it and password protect it, and then unhide it so we (Company A) can see it, won't Company B be able to see it as well, since it exists as a real-time file? That would render the password protection useless. Is what I seek possible?

    TL;DR: Workbook is real-time and shared between two parties. Let party A see Worksheet 1 when they enter the password, but hide worksheet 1 from party B at all times.

    Thanks
    Last edited by enmar; 07-18-2012 at 08:35 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Hide Worksheet in Real-Time Environment for Those Without Password

    The answer to this depends on a couple of things.

    Firstly that you can run macros on the workbook, secondly (and more importantly) the importance of the confidentiality of the document. The only (really) secure way of locking a worksheet from viewing is not to include it in the workbook.

    In summary if you are only interested in stopping the casual user from viewing the worksheet and are able to run macros, then this is possible.
    If you can't run macros/there would be implications if a tech savvy user from the other organisation read the data, then you need to review the entire solution

    Hope that helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1