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
Bookmarks