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.

On Mar 27, 10:49 am, "bbdog" <ayne...@yahoo.co.uk> wrote:
> 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.

Wrong group for that question - go to ...Excel.Programming