OOo macro security problem and work-around

OpenOffice, FaxWorks, etc.
User avatar
Eugene Gorbunoff
Site Admin
Posts: 685
Joined: Sat Apr 09, 2005 11:18
Location: St.Petersburg, Russia

OOo macro security problem and work-around

Postby Eugene Gorbunoff » Thu Mar 05, 2009 01:58

Christian Hennecke

I just discovered that with OOo for eCS it is impossible to use any
macros other than the ones that come with OOo itself: By default macro
security is set to high which suppresses execution of macros that are
not marked as trusted. Well, you cannot invoke the related settings
dialog to change that because this very dialog is implemented in Java
and the eCS version does not support Java. I can tell you, I was about
to apply a number of medieval manners of death to certain guys.

After spending quite a bit of time on searching the net and
configuration files (It's a freaking 3:15 AM now!), I have been able to
change the setting the following way:

Close OOo. Go to the directory
%HOME%\OpenOffice.org2\user\registry\data\org\openoffice\Office\ and
open the file "Common.xcu".

Scroll to the end of the file. The last XML tag should be
"</oor:component-data>". Before that tag, insert the following:

Code: Select all

 <node oor:name="Security">
  <node oor:name="Scripting">
   <prop oor:name="MacroSecurityLevel" oor:type="xs:int">

Save the file. This will change the value for macro security to 0
(zero). Valid values are 0 (lowest) to 3 (highest). The default is 2.

So... As long as OOo for eCS does not support Java, please provide at
least a REXX script that lets users adjust the macro security level!

Return to “Office suites and apps / Офисные пакеты и утилиты”

Who is online

Users browsing this forum: No registered users and 2 guests