Are you using the .ods format? Macros would not, I think, be converted to the .xls format.
Mark Knecht wrote: > > 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 >> > > > -- View this message in context: http://www.nabble.com/Macros-not-active-on-new-machine--tf3937729.html#a11243994 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
