Run Macro when User click to view Sheet

[sbi-tech]

I want to run a macro only when the user clicks on the “JobDetails” sheet tab in LibreOffice Calc. Mean on view. How can I achieve this in LibreOffice Calc

[fpy]

Calc Sheet Activate event?

@elmau From the OQ, I understand he wants to intercept a sheet change event, not the document activation one. @vib If I understand your question correctly, no there’s currently no such event as Sheet change that could be specified in the document events. You’ll have to set a listener for that. Here’s how I do it, from some working code: Option Explicit '-------------------------------------------------------------------- Public gHandlingSheetChangeEvent As Boolean 'flag that avoids to fir…

Sheet Events
Macros/Basic/Calc/Sheets - The Document Foundation Wiki

[sbi-tech]

Thanks, I create a listener, it work perfectly.