View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Macro to return to original cell

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


--
Regards
Dave Hawley
www.ozgrid.com
"Tonso" wrote in message
...
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