Hiding Excel Sheets from specific users

Question

I have an excel file uploaded on OneDrive and have shared it with a team. It's a daily activity report so I want certain members to only be able to view their own sheets. I can set passwords on each sheet to lock edits but I do not know how to allow them to view only their own sheet.

Answer 1

my experience about this, either using automation tool VBA to do some operations while the workbook opening, or just dividing the entire workbook into several workbooks depending on the needs.
and I prefer the last one. VBA is outdated and doesn't actually auto-run when the workbook being 1st opened. That way everyone could be able to see those dedicated sheets that you don't want before they click the security warning and allow VBA to run.

Thus, you can use VBA to

• divide the entire workbook into several workbooks such as 4 for every department in the team
• add a workbook open password
• copy and paste to the OneDrive folder

and tell each department their own password to open the workbook.

That is my solution in Excel framework only. But furthermore, I think the best way to solve this is to create several folders to share in OneDrive.