[Solved] Start a macro when file is open

[florin]

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

[JohnV]

One Calc file or every Calc file?

[Zizi64]

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:

[florin]

Just one Calc file.
Thank you all.

[JohnV]

Was this enough to solve your problem?

[florin]

Yes, thank you.