Hi Anthony, The macro was developed on the first machine and in the spreadsheet that I wanted to use it in. That spreadsheet should (I think) already have the macro in it, shouldn't it?
However when I move that spreadsheet to a second machine I don't see the macro in the spreadsheet on the second machine. I go back to the first machine and look at the spreadsheet I emailed and I do see it. This leaves me confused as to where the macro resides. Is it in the spreadsheet on the first machine or is it in OpenOffice on the first machine? Is there anything I need to do on the second machine to enable macros? I was guessing that maybe the second machine cannot run macros at all until I enable some setting but I haven't found that yet. I'll try exporting the macro and moving it to the second machine and then importing it there. Thanks for your help. cheers, Mark On 6/18/07, Anthony Chilco <[EMAIL PROTECTED]> wrote:
Hi Mark, On the PC where the macros work, go to the organize macros dialogue, click the 'Organizer' button and select the 'Libraries' tab. Find the macro, select it and click the 'export' button. Select the spreadsheet that you want them macro in, then click the import button. Import the library that you just exported. Save the spreadsheet. tc Mark Knecht wrote: > Hello, > I have a spreadsheet that has some conditional formatting macros in > it. If I email this spreadsheet to myself and then download it on a > new PC it seems the macros either aren't in the spreadsheet or aren't > activated. > > When I look in Tools-Macros->Organize Macros->Openoffice.org Basic > on the machine where they aren't working it seems I don't see the > macro that I see on the original machine. > > How do I transfer the macro as part of the spreadsheet so that > another user can use it? > > Thanks, > Mark > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
