Agree - have just tried deleting the macro's and agree it seems hard, if not impossible, to do.
However you can set your macro security (tools>options>openoffice.org>security) settings to 'very high' and add the path to this file in the 'trusted list'. If you do this then you will not get prompted when opening the file. /paul On 5/7/05, Paul Wright <[EMAIL PROTECTED]> wrote: > I'm editing some Excel workbooks in OOo 2.0. Whenever I open the files, > I get a warning of macros and a dialog to enable or disable them. > Typically, I disable them. Doesn't seem to make much difference since > they don't function in OOo. The spreadsheets always have an added sheet > named VBA_0. I have tried deleting the sheet and also working through > the OOo macro editor but I cannot seem to get rid of these macros. When > I reload the workbook, both the macro warning and the VBA sheet are > there again. Since I am continually reopening and modifying data, I > would like to get rid of the macros. > > I don't want to go to another format because the macros were there to > create some formatting that Excel doesn't normally have. I created the > first sheet as an ods file, but it turns out that OOo can handle more > text in a cell than Excel. And I have to deliver the finished product > to an Excel user. One of the angels at WOPR Lounge provided the macro > to modify the formatting and I don't want to lose that now. But I would > like to get rid of the macros themselves. > > I guess I could take them back to the Excel machine but it would be nice > to get rid of them here. > > -----Paul----- > > --------------------------------------------------------------------- > 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]
