Hi,

Is there VBA code I can use to loop the same action in certain sheets within a workbook (not all sheets, and I don't want to 'exclude' specific sheets). I'd like the code to go down a list of sheet names within a specified range. This way, if there are additional sheets I need to add later, I can just add it to the bottom of a range without having to edit a list of sheet names within the code. An incorrect version of the function is below:

Sub SetProtectionPropertiesAsLockedinSheets ()

Dim FcstSheetName as String

Windows("2015 RF Macro.xlsm").Activate
Range("H9").Select
FcstSheetName = ActiveCell
Windows("CLIENT - 2015 Q1RF.xlsx").Activate
Sheets(FcstSheetName).Activate
Cells.Select
Selection.Locked = True
Selection.FormulaHidden = False

[...]

In the '2015 RF Macro.xlsm' file, range H9:H15 lists names of sheets in the 'CLIENT - 2015 Q1RF.xlsx' workbook. Once it gets to the bottom of the list, I'd like it to move onto the next action in the code

Hoping this isn't a difficult ask. I've Googled and couldn't find anything that does it the way I'm looking for.
Let me know if my ask is unclear

Thank you!