Passing variables

Good morning lordfa9

Try putting this module into the ThisWorkbook module :

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
a = Sh.Name
End Sub

and put this code in a normal module. This is the code that your back button needs to link into. The above module just keeps a constant track of the last sheet.

Public a
Sub test()
Sheets(a).Activate
End Sub

This will only give you one level of going back - there will be no history.

HTH

DominicB

Good morning lordfa9

From Excel press Alt + F11 to go to the VBE.
Find your project on the left hand side (eg, VBAProject (Book1.xls))
Make sure it's expanded
Double click on the ThisWorkbook text
A new window should open on the right with two dropdowns at the top - General and Declarations. This is the ThisWorkbook module. Paste the code into here.

HTH

DominicB