Macros

[mrparker99]

I have a large Excel spreadsheet with numerous Macros. How do I turn an or allow Macros in Open Office Calc? Does each macro have to be individually activated or can you allow all macros for a given spreadsheet?
Thanks

[acknak]

Running macros is controlled by the security setting. Since macros in a document are a huge security concern, the default security setting is "High", which prevents macros in a document from running, unless the document was saved in a location marked as secure.

Tools > Options > OO.org > Security > Macro Security

The other problem will be running the macros at all, since MS' VBA is simila, but not identical, to OOo's BASIC.

The macros are not likely to work without some translation efforts.

[mrparker99]

Thanks, I will try changing settings and see what happens.