Hello I'm quite stuck, I'm trying to create a macro while the worksheet
is protected and the thing is i click unprotect and the password
dialogue box appears asking me to enter password which is fine, but can
i create a macro so that when it is played it opens this dialogue box
for me to enter password to unprotect sheet?

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=526090