I have a system where a user can click on a button to view a chart. I need to
back button on the chart to return to the previous sheet. The user can view
the charts on different sheets so referencing one sheet to return to is not
suitable. The code I have is

Dim wslastsheet As Worksheet
Set wslastsheet = ActiveSheet
Sheets("ChartGSE").Select
wslastsheet.Activate

(This was suggested yesterday in a reply to a previous msg) The problem is
that the chart appears for half a second before returning to the previous
page. The good thing is that is always returns to the previous page, even if
the option to view the graph is made from different sheets. Is there a way of
stopping this quick view of the chart before it close?

Alternativly the chart could appear in a window (it is currently a sheet)
which the user could close.

I appreciate any help

Thanks

Nathan