Apache OpenOffice Community Forum

Posted: **Tue Oct 12, 2010 12:04 pm**

Hello

1. I want to run a macro when the file is open (in Calc). How can I do this ? (Workbook_Open in excel)

2. If the macro security is set to high how can I close the file after it is open (if it is not possible do not open the file; or display an empty tab).

Thanks
Florin

Posted: **Tue Oct 12, 2010 5:44 pm**

One Calc file or every Calc file?

Posted: **Tue Oct 12, 2010 10:21 pm**

1. I want to run a macro when the file is open (in Calc). How can I do this ?

Here is an example.

This is a minimal macro:

Code: Select all

Sub Run_at_open
Print "This macro runs when this file opened"
End Sub

The macro located in this file:

Run_at_opening.ods: (8.12 KiB) Downloaded 1723 times

Setting of Open Document event:

Posted: **Wed Oct 13, 2010 6:42 am**

Just one Calc file.
Thank you all.

Posted: **Wed Oct 13, 2010 4:57 pm**

Was this enough to solve your problem?

Posted: **Thu Oct 14, 2010 6:54 am**

Yes, thank you.

Apache OpenOffice Community Forum

[Solved] Start a macro when file is open

[Solved] Start a macro when file is open

Re: Start a macro when file is open

Re: Start a macro when file is open

Re: Start a macro when file is open

Re: Start a macro when file is open

Re: Start a macro when file is open