GOTO PREVIOUS...?
 

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!

GOTO PREVIOUS...?
 

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

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.