how to prompt for pw in Protect sheet macro?
Posted by robert on August 23, 2001 3:04 PM
Is there a way to prompt a user for a password while running a Protect sheet macro? activesheet.protect just automatically assings a null password. I tried utilizing the code provided in the 08/05 posting titled Protect Sheet Macro (which used a prespecified password) but I am having difficulting assigning a variable to prompt for a password to enter. Any assistance would be greatly appreciated.