| View previous topic :: View next topic |
| Author |
Message |
wtjiao
Newbie
Joined: 10 Feb 2011
Posts: 4
|
 Posted: Thu Feb 10, 2011 12:37 am Post subject: Worksheet_FollowHyperlink in Excel equivalent to Calc |
 |
|
I am converting an Excel file to OpenOffice Calc which handles showing and hiding of sheet based on the clicked hyperlink. Usual flow is clicking a hyperlink will hide the current sheet and then show a previously hidden one. I used the Worksheet_FollowHyperlink((ByVal Target As Hyperlink) event in Excel to identify which Hyperlink is clicked so that I can show the appropriate sheet.
Thanks in advance! |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Feb 10, 2011 1:44 am Post subject: |
|
|
Use scenarios instead. They work in both applications.
Macro questions should be asked in the macro forum. This has nothing to do with Calc. This method would be the same in the whole office suite. I don't know the method.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
