I have excel 2000 and I wish to create a macro but have limited
knowledge. What I am trying to achieve is, I want a shared document
that is read only to users but by clicking a macro users get a
password prompt which will then allow them write access to certain
columns or cells which can then be saved.
Is this possible and if so how?

Any help would be greatly appreciated.