Activesheet.previous.Select

Perhaps using the workbook level SheetChange event. (if changes are made by
users).

If you share the workbook under the Tools menu, Excel will build a history
for you. See help for details.

--
Regards,
Tom Ogilvy

"Mara" wrote in message
...
1. I have a workbook with several worksheets, and would
like to creat a back button so that when I am looking at
my diagram wooksheet I am able to return to the previous
worksheet. I am not sure what the code would be enable to
do this, do you?


2. I would like to some how keep updated records on how
particular items are performing on a daily basis, is there
a way to flag a cell that has been updated on that
particulare day and keep track of the info in an
inconspicuas way so it is not shown on the main
worksheet.


I hope my questions make sence and someone can help me
with them..............