Bob has pretty much laid out what you need.
Sounds like you are having difficulty with what he has written.

So let's start anew...

Post your code again and give us a concise description of what is happening
or not happening.

It does sound like all you need to do is wrap your code with unprotect and
protect

Sub MySub()
Activesheet.Unprotect

'Do my stuff

Activesheet.Protect
End Sub

--
steveB

Remove "AYN" from email to respond
"huntermcg" wrote in
message ...

Hello Bob or any PRO reading this,

If you have a suggestion please reply to my last post.

Best regards, Hunter


--
huntermcg
------------------------------------------------------------------------
huntermcg's Profile:
http://www.excelforum.com/member.php...o&userid=19391
View this thread: http://www.excelforum.com/showthread...hreadid=469683