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?