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

Creating a macro - Writing a Script - Using the API

[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

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


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests