Results 1 to 2 of 2

Hide Worksheet in Real-Time Environment for Those Without Password

Threaded View

  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.

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