Setting worksheet protection password in VBA
 

"Tim Lund" wrote in message ...
In VB, how can I get a prompt for a password to come up?
When I record a macro, all I get in activesheet.protect
and some stuff about objects, etc, but nothing to prompt
for password.

Tim

activesheet.protect password:= opensesame or activesheet.unprotect opensesame