VBA question

[john23]

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?

 

[Tom Ogilvy]

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_...=microsoft.public.excel.programming&lr=&hl=en

put the above all on one line.