When opening third party spreadsheets, often times I get the following dialog box message: " This document contains macros. Macros may contain viruses. Execution of macros is disabled due to the current macro security settings in Tool-Options-OpenOffice-Security. Therefore, some functionality may not be available." Usually I ignore the message and proceed without enabling macros.
I have a habit of trying to check out the host site offering the spreadsheet and verify they can at least pass the straight face test.
Question: If I change the macro settings in Calc on any spreadsheet, will the the updated settings remain so I can open additional spreadsheets in the future without having to change the settings again?
In my experience, downloading spreadsheets written for Excel hasn't presented too many problems. Just trying to make this step as seamless as possible.
Any thoughts or advice would be welcome.
Thanks.
Enabling macros — What setting should I use?
-
- Posts: 14
- Joined: Fri Oct 11, 2013 1:24 am
Enabling macros — What setting should I use?
Apache Open Office 4.0.1
Windows Vista Business
Windows Vista Business
Re: enabling macros
The macro security setting is for the suite as a whole, so any change will affect all documents. You can set it to Medium so that you are asked about enabling the macros when the file is opened. You can then decline or accept depending on the file.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 14
- Joined: Fri Oct 11, 2013 1:24 am
Solved Re: enabling macros
Medium setting it is.
Thanks.
Thanks.
Apache Open Office 4.0.1
Windows Vista Business
Windows Vista Business
Re: Enabling macros
You can also set a "trusted location" so any documents saved to this location will run the macros without prompting. So if you have a sheet you trust and want to use with macros, save them in the "trusted" folder. This is set in the macro security window, "Trusted Sources" tab.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
Re: Enabling macros
Hey guys, I get that same error, but cannot find in 4.1's calc where I can re-enable macros. On the mac version there is no Tools -> Options -> OpenOffice -> Security
Mollask
OpenOffice 4.1.1 ??? OS X 10.12.6
"The art challenges the technology, and the technology inspires the art." ~ John Lasseter
OpenOffice 4.1.1 ??? OS X 10.12.6
"The art challenges the technology, and the technology inspires the art." ~ John Lasseter
- Hagar Delest
- Moderator
- Posts: 32668
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Enabling macros
The Tools menu is called "Preferences" on a Mac.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Enabling macros
If you are new to Mac and Apache OpenOffice you may find Tutorial: Mac FAQ a useful resource.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers