Здравствуйте Glen,
Monday, May 01, 2006, 11:47:28 PM, Вы написали:
GP> I know that the user can get back to a Sheet from where they originally
GP> clicked on the hyperlink ( that brought them to the current definition
GP> page ) by executing:
GP> Control-G <ENTER>
It corresponds to Application.GoTo method call.
GP> ( Control-G here brings up the "Go To" dialog box, listing a
GP> series of "References", one of which is highlighted, which is the
GP> reference for the sheet from where they came.
These series of references are the Application.PreviousSelections
property. This property is 4-element array. Previous selection is always
first
element. So You can create on definition sheet the command button
and put in its OnCliCk event handler following code
Application.Goto Reference:=Application.PreviousSelections(1)
Or You can create an hyperlink and dinamycally adjust its
SubAddress property, but its more sofisticated.
P.S. Excuse my English (and VBA too :))
--
С уважением,
Сергей mailto:[EMAIL PROTECTED]
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
