User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

Skip to content

[Solved ] Calc. Run macro when specific sheet is selected

Creating a macro - Writing a Script - Using the API
Post a reply

[Solved ] Calc. Run macro when specific sheet is selected

Postby 72saab » Thu Apr 27, 2017 1:21 am

I have a calc spreadsheet containing several sheets. I want to run a macro automatically whenever a specific sheet is selected but I can't find an event for this.
Last edited by 72saab on Thu Apr 27, 2017 4:16 am, edited 3 times in total.
OpenOffice 5.2 on Ubuntu 17.04
72saab
 
Posts: 3
Joined: Thu Apr 27, 2017 1:06 am
Top

Re: Calc. Run macro when specific sheet is selected

Postby 72saab » Thu Apr 27, 2017 4:00 am

Nevermind.. Found it by right clicking sheet tab, then 'Sheet Events', then 'Activate Document'.
OpenOffice 5.2 on Ubuntu 17.04
72saab
 
Posts: 3
Joined: Thu Apr 27, 2017 1:06 am
Top
Post a reply

Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 11 guests

Apache Software Foundation Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these
Policies and Terms of Use 		Get OpenOffice
Get OpenOffice