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?

There is no object that supports unprotecting the VBA environment other then
Send keys.

You can search this group at google groups for the sendkeys code.

http://groups.google.com/groups?as_q...ng&lr= &hl=en

put the above all on one line.

--
Regards,
Tom Ogilvy

"john23" wrote in message
...
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?