I have a DDE link that pulls in certain information to my spreadsheet.
Occassionally the link goes down, but unless the user is really paying
attention they may not know the data is stale. When the user depresses
Ctrl+Shift+R, it refreshes the link (whether it is current or not), but I am
tired of people asking what the combination is (because they forget). I'd
like to:
a.) create a button that operates the keyboard stroke Ctrl+Shift+R
or (better)
b.) create a funtion that automatically launches the keyboard stroke at
timed intervals.

If possible as well, is there a way to set up a notification if the link is
down? (like a cell that contains the value "Live" when it is communicating
and "Dead" when it isn't)