View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] BartParry@gmail.com is offline
external usenet poster
 
Posts: 6
Default GOTO PREVIOUS...?

On Jul 10, 12:10 pm, wrote:
On Jul 10, 11:58 am, allgirlusa
wrote:

Is there a way to create the equivalent of a "BACK" button on a sheet so that
when the link is clicked it will navigate back to the last active sheet? I
cannot find any information.


Any help is greatly appreciated! Thanks!


using a command button either activesheet.previous.select or if you
know the sheetname will be constant (ie sheet1) you can use
sheet1.select


actually, going to the last ACTIVE sheet could be a little more
difficult if you can't eliminate which sheets they could be coming
from.