Paul Wright 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-----
Hi Paul,
It sounds like you want to save your macros, but get rid of them. Perhaps if I read it again I would get it (I can be rather dense at times, just ask my Wife).
Suggestion 1: Work and experiement with a COPY and assume that what I will tell you to do now will cause you to LOSE everything. Got it?
Suggestion 2: Make a backup. Wait, that is Suggestion 1.
Suggestion 3: Use Tools | Options | Load/Save | VBA Settings
This will probably address the issues that you have.
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
