I never use Option Explicit so not used defining variables.
![]()
Private Sub Workbook_Open() Dim SHEETList, sht SHEETList = Array("TTL APAC", "Japan", "Korea", "HK Hub", "China", "HMT", "ANZ", "SEA") For Each sht In SHEETList Sheets(sht).Protect Password:="xxxxx" Next sht End Sub
Bookmarks