thank you for this, although its not quite addressing the problem.
but this could be my fault in not having the write to document set as
read only.

What about applying sheet protection? This requires users to enter a
password in order to edit content. VBA can edit if you set it up
correctly and lock the project.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion