Storing "Last Sheet" Info in a cell

[duncanhalleastey]

Hi all,

I'm by no means an excel wizard and have no doubt that his is a simple function so bare with/forgive my ignorance..

I have simple links across several sheets (January-December) that skip to a hidden sheet (Notes and Comments).

I want the "back button" in Notes to take the user back to the sheet they came from but don't know the function I should be using to capture the navigating sheets info from to load into either another simple link, or, button.

Hopefully I've done a good enough job of explaining what I'm trying to do here, and any help will be greatly apprecaited.

Thank you!

 

[Tetra201]

Try placing the following subs in the workbook code section (not in a module) and assigning the Button1_Click sub to the "back button:"

Dim sName As String
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    sName = Sh.Name
End Sub
Private Sub Button1_Click()
    Sheets(sName).Activate
End Sub