MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!