I have built a budget worksheet that relies on linked detail sheets to update
the budget. In "Budget Summary.xls" it lists all account numbers. Each
account number has a hyperlink (using Worksheet_FollowHyperlink) that opens
the detail budget entry workbook for that account. So, if I click on
"40000", then "Detail - 40000.xls" opens.

"Budget Summary.xls" has links to the detail entry sheets to show the
monthly budgeted amounts. These update automatically when the workbook
opens. So say I open "Detail - 40000.xls" with the hyperlink. My detail
workbook has two command buttons - one saves the changes, closes detail, and
returns to "Budget Summary.xls" and one does not save changes, closes detail
and returns to "Budget Summary.xls".

Here's my problem, if a user makes changes to "Detail - 40000.xls" but
decides they don't want them and clicks the second button to not save the
changes, "Budget Summary.xls" retains the changes even though they weren't
saved. If I refresh the links, then the original saved values will return on
"Budget Summary.xls". What I would like to do is automate via VBA so that if
the user clicks on the second command button in the detail file (i.e., don't
save changes) then my "Budget Summary.xls" file will return to it's original
state. Any help would be appreciated!
--
Thanks,

Gerry O.