Macro to return to original cell

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

I have an xl2003 workbook that is rather complex. I would like to have
a "Help" button on the main worksheet, worksheet "A", that would would
go to another worksheet named "Help", which would contain other
buttons linking to different Help topics on worksheet "Help". When the
user is finished getting help, i would like to have another button
that would, when selected, take the user from where ever he was on he
"Help" worksheet, back to the cell they were at on worksheet "A". I
would surely appreciate some "help" on this subject.

Thanks so much,

Tonso
 
At the very top of a standard module enter;
Public rCell as Range

In the ThisWorkbook Module;
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
On Error Resume Next
If Sh.Name <> "Help" Then Set rCell = Target(1, 1)
On Error GoTo 0
End Sub


In your Macro code;
Application.GoTo rCell
 
Back
Top