Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to Close libreoffice spreadsheet after some time, automatically?

I have a spreadsheet that needs to be worked on by everyone in the team (Max. 30 people). Most of the time, people tend to leave the sheet open thereby making it on a read only mode.

If I could get a macro that would close the sheet if its inactive for more than 5 seconds it would be great (similar to timer function in excel).

Example vba for MS Excel is here. http://www.vbaexpress.com/kb/getarticle.php?kb_id=308

How to implement the same in LibreOffice Spreadsheet?

click to hide/show revision 2
retagged

How to Close libreoffice spreadsheet after some time, automatically?

I have a spreadsheet that needs to be worked on by everyone in the team (Max. 30 people). Most of the time, people tend to leave the sheet open thereby making it on a read only mode.

If I could get a macro that would close the sheet if its inactive for more than 5 seconds it would be great (similar to timer function in excel).

Example vba for MS Excel is here. http://www.vbaexpress.com/kb/getarticle.php?kb_id=308

How to implement the same in LibreOffice Spreadsheet?