Hi Folks,
We have a set of Excel Workbooks that are constructed by Perl Win32::OLE scripts. The Workbooks consist of reports in the form of Worksheets. Each Worksheet has a column of Hyperlink Objects that direct the user to one Sheet of a set of "definition pages" (a set of Worksheets at the end of each Workbook ) that gives details on how the values in that row are calculated.
My issue is how to allow the user to "go back" to the page from where they came when they are on a definition page, by either clicking on a hyperlink on the definition page they are currently on, or with a simple Control-Sequence.
I know that the user can get back to a Sheet from where they originally clicked on the hyperlink ( that brought them to the current definition page ) by executing:
Control-G <ENTER>
( Control-G here brings up the "Go To" dialog box, listing a series of "References", one of which is highlighted, which is the reference for the sheet from where they came.
Hitting the ENTER key will bring them back to the sheet from where they came).
I can't construct a Hyperlink Object on these "definition" sheets, because a user could go to one specific definition sheet from any number of Worksheets.
Does anyone know of a solution to allow a user to get back to a Sheet from where they clicked on a hyperlink, other than using the "Control-G <ENTER>" sequence ???
Thanks as always for any help.
Glen Plantz
_______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
