OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

enable macros after spreasheet is loaded?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
davea0511
General User
General User


Joined: 07 Jun 2011
Posts: 21
Location: United States

PostPosted: Wed Jun 13, 2012 11:28 am    Post subject: enable macros after spreasheet is loaded? Reply with quote

Here I am asking questions again that the powers that be would rather not be asked (setting them up for a soap box about standards and the way things should *not* be done). But somebody has to be a pain in the neck, eh? So here goes ...

Is there some way that macros can be enabled after a spreadsheet is loaded? For example, the current process for someone who loads a spreadsheet with macros and the option to load the macros at startup is disabled (OpenOffice security settings), then the only way for them to do so is to go into the security settings, allow that capability, save and close OpenOffice, reopen the spreadsheet, then select "yes".

It would be really nice if there was an easier way for them to enable macros in that case. I think the default is to not even ask when a spreadsheet loads, is it not, so the above process being the default is a bigger pain in the neck than I am.
Back to top
View user's profile Send private message
davea0511
General User
General User


Joined: 07 Jun 2011
Posts: 21
Location: United States

PostPosted: Wed Jun 13, 2012 12:25 pm    Post subject: Reply with quote

I'll take that as a no then, eh?

I'm thinking more and more that I need to package an installer executable with my spreadsheets that automatically configures OO to run in a way that is more friendly than it's default settings. The security settings should be "Medium" by default, not "high", and design mode should be disabled by default. Now I just need to figure out where that config file is and the best way to change it. Hopefully it's XML, JSON, or similar.
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Wed Jun 13, 2012 12:28 pm    Post subject: Reply with quote

Not so fast please, there aren't that many people around anymore answering questions here. Patience. You can also try the new official community forums (see my signature for the link).
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
davea0511
General User
General User


Joined: 07 Jun 2011
Posts: 21
Location: United States

PostPosted: Wed Jun 13, 2012 12:49 pm    Post subject: Reply with quote

Okay, I'll give it a day or so then check out the other forum if I get no bites here. Is this forum going to be phased out?
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Wed Jun 13, 2012 12:51 pm    Post subject: Reply with quote

It gets too much spam, so most active people left.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group