I think the problem you have with Protect worksheet option is you can not
modify any of the cells after protecting the sheet. This is because all the
cells are Locked by default.
Before doing protect worksheets select the cells you want to give the user
access to and go to formatcellsprotection and uncheck Locked. No when you
protect the sheet these cells can be modified.

Vikrant

"kalz" wrote:

Dear All,

I'd like to email my customer a Excel worksheet, however, do not want them
to change any cells (values and formats) from column A to D, only E and
onwards permitted. Also, if I have hidden some rows or column, I do not want
the person to view my hidden parts too.How can I created this effect? I
already tried Protect Worksheet and workbook, doesn't seem to be working.

Thankyou!
kalz