Hi,

I have just started to use macros in Excel worksheets at a basic level, I am
recording the macro using "key strokes" rather than righting the code. (This
I have yet to master)

My problem is that I have a workbook containing several sheets which contain
columns of data that I want to lock. However when the sheets are locked and
the macro run it generates errors. I have read through articles on
unprotecting the sheet but when I try to write these codes into VBA the macro
still doesn't work.

Can anyone give me a simple idiots guide answer

Many thanks

Rob