To protect and unprotect sheets with a specific name using VBA, run a macro like this one:
'Toggles protection on and off for any sheet beginning with "Prepaid"
' Assumes there are no passwords on the sheets.
Dim sh As Worksheet
Dim iCount As Integer
Dim bProtection As Boolean
For Each sh In ActiveWorkbook.Worksheets
If UCase(Left(sh.Name, 7)) = "PREPAID" Then
iCount = iCount + 1
If iCount = 1 And sh.ProtectContents = True Then bProtection = True
If bProtection = False Then
'protect the sheets
'unprotect the sheets
This macro loops through each sheet in your workbook and toggles the protection status. If the sheet name begins with "Prepaid" (case-insensitive), it will toggle protections on or off based on the protection status of the very first "Prepaid" sheet it fines. If the first sheet with your naming convention is protected, that sheet and all subsequent sheets will be unprotected. If it's already unprotected, that sheet and all subsequent sheets will be protected. That way, you can guarantee all the "Prepaid" sheets will have the same protection status.
This macro assumes there are no passwords on the protected sheets and it applies the default protection.