I know its been a while... but when trying this I am unable to get it to
work.

Just inserted a basic protection function (see below)

Im still having the same problem ie cells that were not locked, become
locked when I run a macro Say range a10:c50.

I thought inserting the UserInteraceONly option would resolve this?

Help...



Sub ProtectSheet()

ActiveSheet.Protect , UserInterfaceOnly:=True,
AllowFormattingCells:=True

End Sub







*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!