Back And Forward in Excel

Hi everyone,

Can I create Back and Forward Buttons to move between excel sheets as well as Internet explorer.

For instance, if my active sheet is sheet3 and I move to sheet5 ..

What I want is that when I run the (Go Back) code << I should be taken back to sheet3, which I was on before sheet5.

In addition, when I run the (Forward) code >> I should be taken to sheet5, and so on.

I hope that my query is clear and possible to be applied with VBA.

Thank you,

Hi,

Thank you royUK for your reply, but that is not what I meant ..

I don't want to move to the direct next or previous sheet.

I want to move to the sheet I was on before the active sheet

For example, if I were on sheet3 and then moved directly to sheet5 .. in that case my previous sheet would be sheet3 not sheet4.

I hope that my idea is clearer now,

Originally Posted by royUK

You could store the sheet name in a Public variable

Can you please help me doing that?