VBA question
 

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?

VBA question
 

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?