They would not run because:
1. You must set the security appropriately
Use tools > Options > OOo-dev > Security
click "Macro Security"
Set macro security mode to Medium so that you can at least confirm the
macros that you want to enable.
2. Tell OOo to load and enable the macros
From the options (tools > Options) seelct Load/Save > VBA Properties.
Check Load Basic code (you can do this for three options)
Check Executable code (this option exists only once).
You can also check to save the original basic code, i did, but that is
not the problem.
After this, the VBA scripts are loaded and ready to go. They will still
not work, however, because the macro loads a form, and form support does
not exist in the VBA support for OOo. Much of the other code, however,
will likely work fine (which does not help much since this uses forms).
Anthony Chilco wrote:
Hi David,
OOo v3 beta has limited support for VB macros. I opened your
spreadsheet with it, but the macros would not run.
tc
David Cummings wrote:
Hi
I have a little Excel program that works on several macros and I want
to add some more to it. However, I cannot get it to work in Open
Office Calc. I have been working with this for several years on and
off and my brother and I finally got the pedigree section to work
right. However, when I bring over to OP, I cannot get any thing to
work like I wish.
I am a canary breeder and we who are breeders must keep very accurate
records. This is important for us though it is just a hobby. Most of
us do not make any money with our birds, just recover food cost.
Here are the macros. I can attach the sheets if you all wish.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
