Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to return to original cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF value in a cell, return another cell's value to original cell | Excel Worksheet Functions | |||
Hyperlink to web does not return to original Excel worksheet | Excel Discussion (Misc queries) | |||
Return pivot table fields to their original value after editing | Excel Discussion (Misc queries) | |||
HOW DO I RETURN TO A RECOVERED FILE AFTER CHOOSING ORIGINAL | Excel Discussion (Misc queries) | |||
Why will solver only return the original adjustable cell values? | Excel Worksheet Functions |