Hi Everyone,

This problem suddenly appeared about 2 months ago - I have an access
database that creates excel worksheets that have all the cells, except for
one column, locked. It applies a password to the sheet after data has been
put onto the sheet then saves the excel file to a folder where it is then
emailed to our sales guys out in the field.

I can open the files from this folder fine - the cells that are supposed to
be protected are protected. The one column that is not supposed to be
protected is not. Perfect.

Our sales guys are finding that the cannot enter anything into the cells
that should not be protected. I am using SMTP and bit of VBA to send the
files with a CC back to the sender. The excel in the returned copy works
fine.

They are using Office XP, we are using Office 2003 but I've tested this on
Office XP here and it works.

Any help please would be most appreciated

Cheers

Tom