I have these two codes behind "Sheet1" which is protected
with the password, "spider", the VBA is also protected
with the password, "spider":

Private Sub cbutEmployeesSignature_Click()
TaTFun.Module1.Employee_Signature
End Sub

Private Sub cmdPrintTimeSheet_Click()
TaTFun.Module2.print_timesheet
End Sub

I need a code that will open the VBA behind Sheet1 and
change the first code from
TatFun.Module1.Employee_Signature

to TatFun.Module3.Supervisor_Signature

it then needs re-password protect everything?