Hi Mark,
That is the problem. Any macros in 'My Macros' exist in your application
data only and not any particular spreadsheet. If you're here:
'Tools->Macros->Organize Macros->OpenOffice.org Basic'
I see the macro existing under "My Macros->Standard->Module 1" named
cptoa1.
Click the 'Oragnizer' button and select the libraries tab. With the
location set to 'my macros', select your macro in the 'Library' list.
Click the export button and select a location to save to. Next, change
the location to your spreadsheet that you want the macro in. Click
'import' and browse to the location that you saved the macro. Open the
directory and select the file 'script.xlb'. Save your spreadsheet. To
test that you've been successful, open the 'my macros' version of the
macro and rename it, then try to run it in your spreadsheet.
A more direct way to transport the macro is to open the macro editor and
copy and paste the text of the macro from 'my macros' into your spreadsheet.
tc
Mark Knecht wrote:
Maybe the mistake is having the macro in the My Macros group? Should
it be in the spreadsheet name group?
Anyway, I still cannot get the macros over to the second machine so
I'm really in need of some help.
Thanks,
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
