Hi dominicb,
Thanks for your help. I am up and running thanks to you and I worked out
the same logic and the comma part but I'm please you confirmed it.
Sue

"dominicb" wrote:


Hi Sue

Whoops! Never thought to mention that bit to you ...! Fortunately,
it's quite easy and based on the same syntax as unprotecting it in the
first place:

ActiveSheet.Protect Password:="pass"

Just remember that if you have other parameters set (eg
DrawingObjects:=True, Contents:=True, Scenarios:=True etc) just
remember to set your password apart from those with a comma.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=482553