William Case wrote: > Hi Terry: > > On Thu, 2006-17-08 at 03:23 +0000, Terry wrote: > >> William Case <billlinux <at> rogers.com> writes: >> >> >> .... >> >>> I have spent this evening creating test recorded macros. I have the >>> following anomalies. Test macros saved to My Macros -> TestLibarary >>> continue to appear and function after closing and re-logging in. >>> However, the test macros recorded and saved to my project continue to >>> disappear. I double checked that I had, in fact, saved to my project >>> library. All record of project macros, modules and libraries are gone, >>> nowhere on my machine, de nada, rein, nothing. >>> >>> >> I'm assuming that "my project" is a library in a document. You need >> actually to >> save the document as an .ods file (I recall that you are working in Calc.) >> The >> document has to be open before you can see or access its macro libraries. >> >> Is that the answer? If not, have I misunderstood the situation? >> > > Yes. I wrote "my project library" because the actual library I created > keeps disappearing on closing. It was actually called MemberLib. And, > was created using the BASIC Macro Organizer under the project file named > MemberTest2.xls (i.e. Location). Modules and Macros were subsequently > added. Recorded macros for the MemberTest2 project were saved to the > MemberLib library. > > William:
I see your problem. You cannot add OpenOffice.org macros to an Excel Spreadsheet, at least not yet. You will have to save your document in the OpenDocument Spreadsheet (ODS) or .ods file format. James M. Mac OS X, QA Team Lead --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
