OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Worksheet_FollowHyperlink in Excel equivalent to Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
wtjiao
Newbie
Newbie


Joined: 10 Feb 2011
Posts: 4

PostPosted: Thu Feb 10, 2011 12:37 am    Post subject: Worksheet_FollowHyperlink in Excel equivalent to Calc Reply with quote

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
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Feb 10, 2011 1:44 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group