Protect a shared workbook

[JD2]

Dear Excel Gurus,

One of my colleagues has an Excel spreadsheet which is shared amongst
several users (who need to use it simultaneously). On one of the sheets, he
wishes to protect the first two columns of four columns so they can view the
information but not change it. They need to be able to put their name in the
fourth column though and use the first two columns to reference it so they
put it in the right place.

I understand that protecting a shared workbook in Excel 2003 is not
possible. Does anyone know a workaround this? Has anyone perhaps written
some VBA to get around it?

Would appreciate any suggestions you have.

Kind regards
JD2

 

[The Code Cage Team]

You can protect the workbook before its shared, you cannot change th
options once shared

--
The Code Cage Tea

Regards,
The Code Cage Team
www.thecodecage.co