Lux Aeterna
Board Regular
- Joined
- Aug 27, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
Hello there!
We use a workbook that has some sheets which I need to be password-protected from viewing. My main concern is that because my colleagues are not very adept at using computers, they might accidentally delete data.
I know I can lock cells and sheets, but that wouldn't be of much help, as I have to edit those sheets regularly, and I might forget to lock them back. I also know I can hide them, but that wouldn't be of much help either, as some of my colleagues need to have access too. So, I thought it would be better to ask for a password each time someone tries to view that sheet.
The sheet names I need to be password-protected are all named List**** (e.g., List2022, List2023, etc.). Please note that there are macros that copy data from other sheets to the List**** sheets. It might be necessary to allow macro-induced commands.
Thank you in advance!
We use a workbook that has some sheets which I need to be password-protected from viewing. My main concern is that because my colleagues are not very adept at using computers, they might accidentally delete data.
I know I can lock cells and sheets, but that wouldn't be of much help, as I have to edit those sheets regularly, and I might forget to lock them back. I also know I can hide them, but that wouldn't be of much help either, as some of my colleagues need to have access too. So, I thought it would be better to ask for a password each time someone tries to view that sheet.
The sheet names I need to be password-protected are all named List**** (e.g., List2022, List2023, etc.). Please note that there are macros that copy data from other sheets to the List**** sheets. It might be necessary to allow macro-induced commands.
Thank you in advance!