With a shared workbook, I would expect it to open at the last position it was saved at - by whosever did that save. If you use the macro, though, that will override the last-saved position.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]