Hi,

Does anyone know how to protect a Excel Workbook file from being modified?
Allowing read but not write by enyone apart from the creater (without requiring password) and also to be saved always in the same directory with the original file name on the network.
I have never written a macro in excel, so be kind, although I know Ms access and a bit of VB.

thanks

dfuas

Quick and easy way is:
File/Save As
Look at the top right of the save as dialog for the "Tools" dropdown.
Select "General Options"
Enter a "password to modify".
Click OK