In video I share some the ways on how to protect a worksheet with unlocked specific cells or ranges, and how to deeply hide the meta data sheets and lock the VBA codes view by VBA project properties.
in the video you may find the ceration steps on:
Unblock specific cells with "Protect Sheet"
Allow Edit Ranges with "Protect Sheet"
Hide Sheets by "Protect Workbook"
Hide Sheets and Block VBA code view by VBA project Properties.
For more info of my BI & Analytics, please refer to the following website links:
My BI & Analytics Website:
https://sites.google.com/view/mikegua...
My blog website :
https://mikeyubianalytics.blogspot.com/