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!
Bookmarks