I'm hoping this is an easy one for someone.
I have a macro that writes data to an archive sheet every time a button is pressed. This works fine.
However I now want the archive sheet viewable to everyone but only updateable by either the marco or a password.
to do this i have saved the Archive with a password to modify. That way users can open as read only. However i do not know what addition i need to make to my macro for it to open the Archive to add data to it.
So for instance i currently have:

Workbooks.Open (ExcelFileB), Password:= "12345"

but this is no help with the read only setting. I thought perhaps it would be a simple Workbooks.Modify, password "12345". or something like that.

can anyone help please?
PS this is Excel 2003