GOTO PREVIOUS...?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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

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.
 
Back
Top