My Tools, Options, Security menu doesn't exist?!?

users
#1

Hello

I am hoping someone can help me here. Thanks in advance!

I have installed LibreOffice on my Mac and am opening a spreadsheet that has
macro's in it. I get a warning that says macros contain viruses and I don't
have macros enable and so I need to go to "Tools - Options - LibreOffice -
Security" to enable it...

I also googled this message and found this page:
http://help.libreoffice.org/3.3/Common/Security

However, I don't have the "Tools - Options - LibreOffice - Security" menu
navigation :frowning:

Anyone have any idea how I enable macro's as suggested in the above URL when
I don't have this menu navigation or am I just looking in the wrong place...
I've navigated the menu system and cannot find anything in the "Tools -
Macros" menu that helps me either.

Thanks for any help or guidance...

#2

Hi :slight_smile:
I don't understand Macros but Chapter 13 here
http://www.libreoffice.org/get-help/documentation/
might help. Which file-format is the file in? Is it an .xls or .xlsX (from MS
Excel) or is it an .ods? MS do their macros slightly differently so it can take
a bit of lkuck gettign them to work sometimes. There are compatibility switches
on
Tools - Options
but i'm not sure if they really help with macros.

Hopefully someone might be able to give a better answer later! Apols for this
one.
Good luck and regards from
Tom :slight_smile:

#3

floridabrits wrote:

Hello

I am hoping someone can help me here. Thanks in advance!

I have installed LibreOffice on my Mac and am opening a spreadsheet that has
macro's in it. I get a warning that says macros contain viruses and I don't
have macros enable and so I need to go to "Tools - Options - LibreOffice -
Security" to enable it...

I also googled this message and found this page:
http://help.libreoffice.org/3.3/Common/Security

However, I don't have the "Tools - Options - LibreOffice - Security" menu
navigation :frowning:

Anyone have any idea how I enable macro's as suggested in the above URL when
I don't have this menu navigation or am I just looking in the wrong place...
I've navigated the menu system and cannot find anything in the "Tools -
Macros" menu that helps me either.

Thanks for any help or guidance...

--
View this message in context:
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-

exist-tp3166597p3166597.html

Sent from the Users mailing list archive at Nabble.com.

Hi. I believe you should be able to see what you need here:
Menu - Tools/Options/LibreOffice/Security. On that page you should see a Macro
Security button which leads to a dialogue where you can trust macros to work
correctly.

You may also need go to Tools/Options/LibreOffice/General and tick Enable
experimental (unstable) features as well.

I am not on a MAC, but this may help, I hope :slight_smile:

best regards

Dave

Using
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1
on openSUSE 11.4 64 bit

#4

Thanks for the quick response Tom. It is an ODS file...

I just don't understand why I don't have this tools/options menu that is
discussed.

Anyone?

Thanks in advance for your help and suggestions...

/g

#5

floridabrits wrote:

Thanks for the quick response Tom. It is an ODS file...

I just don't understand why I don't have this tools/options menu that is
discussed.

Anyone?

Thanks in advance for your help and suggestions...

/g

--
View this message in context:
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-

exist-tp3166597p3166878.html

Sent from the Users mailing list archive at Nabble.com.

Hi again. Perhaps my explanation confused slightly. Go to the Tools menu, then
select options. This will present the LibreOffice configuration dialogue.
Expand the LibreOffice heading then you should see both the Security and
General headings. Select Security and you should see the following dialogue:

http://dl.dropbox.com/u/21689478/Macro%20Security.png

As stated previously you may also need to select General and tset a tick in
the Enable experimental (unstable) features as well.

HTH.

Best regards, Dave

#6

On Macs it is /Preferences.

Larry

#7

A-ha... I am finally sorted... thanks Larry...

I did look under the preferences but couldn't see anything but with further
investigation and poking around I found it! :slight_smile:

Here is the path for others in case they have the same problem...

LibreOffice - Preferences - LibreOffice - Security - Macro Security (then
adjust to what level you want).

Thanks for everyone's prompt responses...

/g

#8

Thanks David... really appreciate the image file to point me in the right
direction... got there in the end :slight_smile:

Cheers!

/g

#9

floridabrits wrote:

Thanks David... really appreciate the image file to point me in the right
direction... got there in the end :slight_smile:

Cheers!

/g

--
View this message in context:
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-

exist-tp3166597p3167576.html

Sent from the Users mailing list archive at Nabble.com.

No problem, glad to hear you got there :slight_smile:

All the best

Dave

#10

Hi :slight_smile:
+1
Congrats for working out how to solve the problem. Good team-work here again.
Thanks for all those answers. I learned some things there, thanks :slight_smile:
Regards from
Tom :slight_smile:

PS I hope to buy a new keyboard today. New fingers would be ideal but just a
new keyboard should help! lol