Hi Everyone

I have a macro running excel file and it is very sensitive. I don't
mind people opening up but I do mind people changing it.

How do I put security such as password to prevent others from editing
the excel file?
i.e. Anyone can open the file and run macro to create a report but
they can't edit anything!!!


p.s. I just know how to put password protection on the whole workbook
and this is useless because no one can open the file lol.


Thank you for your help in advance.

Regards,


James