Kentish_40
New Member
- Joined
- Jun 8, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi I have an Excel file (365) shared on Teams with wrok colleagues. When the file is open, a password is required to see all sheets. if no password is entered, the user can only see a few sheets and the rest are hidden with xlSheetVeryHidden value.
I understand Teams does not run VBA on its Excel viewer and instead users should open the file on the desktop app. I can ask colleagues to do that, however some of them may be curious and open the file on Teams and have access to all sheets. Is there a method how to achieve what is needed?
I understand Teams does not run VBA on its Excel viewer and instead users should open the file on the desktop app. I can ask colleagues to do that, however some of them may be curious and open the file on Teams and have access to all sheets. Is there a method how to achieve what is needed?