Hi, Everyone.
I am currently using a VB code to enforce the enabling of Macros as my workbook heavily relies on VB and Macros.
The code is as follows:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim ws As Worksheet
Sheets("START").Visible = xlSheetVisible
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "START" Then
ws.Visible = xlVeryHidden
End If
Next ws
End Sub
Private Sub Workbook_Open()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
Sheets("START").Visible = xlVeryHidden
Sheets("DO NOT DELETE").Visible = xlVeryHidden
Sheets("Data Sheet").Visible = xlVeryHidden
Sheets("Supervisor Review").Visible = xlHidden
End Sub
the sheet "Supervisor Review" is soft hidden (can be un-hidden by right clicking on the sheet tabs). What I am trying to do is require a password to unhide this specific sheet and this sheet only. I tried to use the basic "Protect Workbook" structure, but that interfers with the enforce macro VB code. Any ideas?
Thanks in advance!
Bookmarks