MACRO PORTING ISSUE

nvgishere · General User Joined: 10 Feb 2010 Posts: 38

Hi
I am facing the following issue.

I ve created a calc file(.ods) with a macro.

Now when somebody else tries to copy this file and open it at their end , they are not able to activate the macro(shows some security issue)

I ve selected the option for macro security and ste it to low.

Still this issue prevails ..

pls help.

JohnV · Posted: Fri Feb 26, 2010 7:01 am Post subject:

The other person must set his own security level. If this is something that will occur frequently then note the Trusted Sources tab where others can set a directory as trusted.

nvgishere · General User Joined: 10 Feb 2010 Posts: 38

Hi...

Can u please elaborate on the "trusted sources tab ", where can i find it.

Is there no way to plug(hard code) the macro to a CALC file(as in my case) and port it to other users .
These users should be able to just run the macro without any security messages being flagged.

JohnV · Posted: Sun Feb 28, 2010 10:16 am Post subject:

nvgishere · General User Joined: 10 Feb 2010 Posts: 38

Hi John,

I did the following procedure..
1) I opened a spreadsheet and named it temp.
2) I opened the tools >macro>organize macro>ooo basic
3) added a new library under temp.ods
4) added a new module under the library
5) added a macro(main) under it, which prints "helo"

But when i click the run button on the macro , i get the following message
"For security reasons you cannot run this macro"
"for more information check the security settings"

However when i add the macro under My macros and dialogues, it works.
I ve set the macro security to LOW.

Still it doesnot work

Pls help.

JohnV · Posted: Tue Mar 02, 2010 6:48 am Post subject:

I have no clue.