[Solved] Prevent "This document contains macros" warning

I have a .xls file that I created several years ago.
When I try to open it using OpenOffice calc, I get a pop-up dialog box saying:
OpenOffice.org 3.2
This document contains macros.
Macros may contain viruses. Execution of macros is disabled due to the current macro security setting in Tools - Options - OpenOffice.org - Security.
Therefore, some functionality may not be available.
[ OK ]
I never intentionally added macros to the document. If there are macros in the document, I do not want them.
I found another post on this forum describing this exact same problem. That post instructs how to delete the unwanted macros, however those instructions did not work for me.
The macros I delete seem to reappear after I save, close, and reopen the document.
Here are my steps to reproduce the problem:
- Double-click on the file foo.xls to open it with OpenOffice calc.
- Dismiss the aforementioned dialog box saying "This document contains macros.".
- Tools -> Macros -> Organize Macros -> OpenOffice.org Basic...
- Click "Organizer..." button
- "Modules" tab: foo.xls -> Standard -> Sheet1: Click "Delete" button.
- "Modules" tab: foo.xls -> Standard -> ThisWorkbook: Click "Delete" button.
- Click "Close" button to close Organizer dialog.
- Click "Close" button to close Macros dialog.
- Save the document.
- Close the document.
- Re-open the document.
=> Get same dialog box saying "This document contains macros.".
- Dismiss the dialog box.
- Tools -> Macros -> Organize Macros -> OpenOffice.org Basic...
- Click "Organizer..." button
- "Modules" tab:
- The following things, which I had previously deleted, have reappeared:
- foo.xls -> Standard -> Sheet1
- foo.xls -> Standard -> ThisWorkbook
I'm using OpenOffice 3.2.1 OOO320m18 (Build 9502)
Windows XP Professional Service Pack 3
When I try to open it using OpenOffice calc, I get a pop-up dialog box saying:
OpenOffice.org 3.2
This document contains macros.
Macros may contain viruses. Execution of macros is disabled due to the current macro security setting in Tools - Options - OpenOffice.org - Security.
Therefore, some functionality may not be available.
[ OK ]
I never intentionally added macros to the document. If there are macros in the document, I do not want them.
I found another post on this forum describing this exact same problem. That post instructs how to delete the unwanted macros, however those instructions did not work for me.
The macros I delete seem to reappear after I save, close, and reopen the document.
Here are my steps to reproduce the problem:
- Double-click on the file foo.xls to open it with OpenOffice calc.
- Dismiss the aforementioned dialog box saying "This document contains macros.".
- Tools -> Macros -> Organize Macros -> OpenOffice.org Basic...
- Click "Organizer..." button
- "Modules" tab: foo.xls -> Standard -> Sheet1: Click "Delete" button.
- "Modules" tab: foo.xls -> Standard -> ThisWorkbook: Click "Delete" button.
- Click "Close" button to close Organizer dialog.
- Click "Close" button to close Macros dialog.
- Save the document.
- Close the document.
- Re-open the document.
=> Get same dialog box saying "This document contains macros.".
- Dismiss the dialog box.
- Tools -> Macros -> Organize Macros -> OpenOffice.org Basic...
- Click "Organizer..." button
- "Modules" tab:
- The following things, which I had previously deleted, have reappeared:
- foo.xls -> Standard -> Sheet1
- foo.xls -> Standard -> ThisWorkbook
I'm using OpenOffice 3.2.1 OOO320m18 (Build 9502)
Windows XP Professional Service Pack 3