Hi,

i have a macro that is currently performing actions on one worksheet. I have copied this worksheet and named it something slightly different. I now want to edit this macro so that it runs it also performs the same actions on the copied sheet. There are many other worksheets in my workbook but only want this macro to be performed on sheets "LS04" and "LS05" (the names i have assigned the worksheets)

The code i have running on the the original worksheet is


Sub Addworkstage()
'
' Addworkstage Macro
'ALLOWS USER TO ADD ADDITIONAL WORK STAGE TO BUILD UP COST ESTIMATE

    Application.ScreenUpdating = False
    LS04.Unprotect Password:=LogCode
    Rows("32:49").Select
    Selection.EntireRow.Hidden = False
    Rows("33:48").Select
    Selection.Copy
    Range("A65536").End(xlUp).Offset(0, 0).Select
    Selection.Insert Shift:=xlDown
    ActiveWindow.SmallScroll Down:=18
    Application.CutCopyMode = False
    Rows("33:48").Select
    Selection.EntireRow.Hidden = True
    Range("A50").Select
    
    If AdminAccess = True Then
    LS04.Unprotect Password:=LogCode
    Else
        
    LS04.Protect Password:=LogCode
    Application.ScreenUpdating = True
    
    End If
End Sub

Thanks in advance for your help