You see that I for get the "set "in my example before lastsheet
See Bob's and J.E's reply


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Use
lastsheet = activesheet

And this to select it for example
lastsheet.select

--
Regards Ron de Bruin
http://www.rondebruin.nl



"NathanG" wrote in message ...
Hi,

I am developing a system where charts are used to display data. Two or more
sheets within the system can go to the a chart. The problem is that I cannot
get the back button to go to the previous sheet on which the user was on. I
have copied the chart sheets to change the code but this does not solve the
problem as new sheets are created with different sheet names so there is no
way to no future sheet names. Is there a way of remembering the sheet before
going to a chart and then being able to return the previous sheet.

I dimed a variable called lastsheet and tried activesheet=lastsheet but I
couldn't get the back button to recognise lastsheet as a sheetname.

Many thanks for your help

Nathan