Passwords in Macros

Posted by Diana on October 31, 2001 12:29 PM

I put wrong email in previous message. It is diana.zemo@starwoodvo.com

Hello,

Posted by robert on October 31, 2001 1:43 PM

In the macro put...

ActiveSheet.Protect password:=InputBox("Enter Password")

This will prompt for a password

Posted by diana on November 01, 2001 4:17 AM

Thanks so much!