I need to make one worksheet the default page in a shared workbook

The 'default page' is whatever was on screen when the workbook was last saved. If you need something else, you'll need a Workbook_Open macro in the workbook's 'ThisWorkbook' module that automatically switches to the required worksheet & range when the workbook is opened. For example:

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

macropod,

Thanks worked great. Now shared users want page to open to last entry, can you help?

cleejr

Simply save the workbook with whatever view you want the workbook to re-open with.

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

That works for me, the person who created the workbook, however the shared users do not default to the last entry (or the desired worksheet until I inserted the code that you suggested) .

Regards,
Chuck

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]