Restricted access to shared file to the specific users

[xxxyyyzzz]

Hi all,

I'd like to ask if there is a possibility to restrict access to the one specific sheet to the user (one of many - 25 max)?
Attached sample file.
Each sheet should be used only by one user and he should have got none access (even read only) to the other sheets. The file will be shared on shared drive.
The file owner should have full access to all sheets.
Users are logging in into windows domain and they are using Excels from 2010 up to 2016 (EN and DE version)
Unfortunately my VBA knowladge is limited to record macro and to modify it or copy a new macro founded in the Internet


Thanks in advance!

ßorg

[TMS]

Shared files are generally problematic and limited in functionality. One of the things you cannot do with a shared file is change worksheet protection. I don't think you can hide or unhide sheets either.

So, short answer, probably not.

As an aside, even if Sheets are hidden, it doesn’t mean you can't access the data on them.