I have a Workbook with 15 pages, the first page is a menu page with several
buttons to navigate through the workbook, on each other page I have a 'home'
button linking back to take the user back to the first page.

My problem arises when the user completes their task cliks on save and then
exits out of the Workbook (this process bypasses the links) - when they
return to the Workbook they are automaticlly taken to the last page they used
not page 1.

I would like a macro that will take the user back to the home page (Page1)
then save their work before exiting.

I have seen several macros that come close but I am unable to create the
correct one can someone help please.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming