OK Found the answer in question/title "Worksheet protection with exceptions"
http://www.microsoft.com/communities...994&sloc=en-us
Thanks
"Ruby Christine" wrote:
I have a worksheet with a crosstab that start at cells F1. I would like to
lockout only the cells is range A1:D10 , protect the sheet and still allow
for all users to refresh the data in the crosstab.