Hi!

Any of you knows how to unprotect an excel sheet from VB. That must include typing the password automatically by my VB program. This is the part where I'm currently stuck!

Anybody can help?

Currently my code to unprotec is like that:

Activesheet.Unprotect

But this code will prompt the Enter password dialog box within Excel whereby the user will need to key in the password. What i want now is for VB to key in the password himself. I've tried to use the Macro to record the steps but it just wouldn't record the part where the password is supposed to be typed...

I'll be very happy if someone can help

Regards,
virux