-when you select "disable" on the macros and after you've done your work, do you save the workbook under a different name than its original? I suspect (I don't know; I'm not that facile with OOo's Calc, which is what you're reading the Excel sheets with) that the disable option that comes up when you open the spreadsheet is good only for the session.
-when you delete the VBA_O sheet and you've done your work, do you save the workbook under a different name than its original?
Finally, if you go to Tools|Options|Load/Save|VBA Properties, unchecking the "Load Basic code to edit" under the Excel 97/2000 area may help on a more permanent basis.
HTH
Eric Hines
At 05/06/05 18:14, you 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]
Out of the argument with ourselves comes poetry, out of the argument with others comes politics.
--Yeats
