Deleted macros returning

[PrivatePIckle]

Hello,

I am new to OO.o and I have never really used macros except using the record function to automate a repetitive task in excel. I have a simple time sheet form that my company created that had a macro that was not used in it so I deleted it (in excel) so the "enable" "disable" dialog wouldn't appear when other people use the form.

I now have switched to OO.o on 2 of my 3 computers and when I open the document I get the warning that there are macros and if I want to enable or disable them. I went to tools-macros-organize macros-openoffice.org basic and found the modules listed for that form and deleted the macros also clicked on organizer and deleted the modules that had the macros. I save and close the form and open it again and the macros are back. The also show up in excel but I can delete them in excel and the stay gone until I open the form in OO.o. This is the latest version of OO.o installed on a new laptop just a couple of days ago.

Thank you for any assistance.

Oh, and when I go to OO.o basic to delete the macros they are listed under standard the modules are named 'sheet 3' and 'thisworkbook' and the macros have the same name. I click to edit them and this is what I see.

Rem Attribute VBA_ModuleType=VBADocumentModule
Sub ThisWorkbook
Rem
End Sub

Rem Attribute VBA_ModuleType=VBADocumentModule
Sub Sheet3
Rem
End Sub

[noranthon]

I cannot get the same result. I've just used the macros organiser to delete a module in a Test.ods, saved it as Test2, closed and reopened it, then used the macros editor to remove a dialogs module I had forgotten, saved, closed and reopened and neither module is there.

If you are sure you are following the correct procedure, try saving the amended document under another name and reopening it. I see no reason why that should make a difference but, also, I see no reason why you should have the problem described.

I take it that the macros are contained in the document' library, not the user "standard" library. If the latter, save the library after deleting the modules. That seems to happen automatically on my system after the organiser is closed but saving the changes will make that certain.

If you still have no luck, select each macro and click the edit button, then right-click on each module tab and select "Delete". Save the document immediately after deleting the modules.
_________________
search forum by month

[PrivatePIckle]

I tried deleting the modules as you described at the end of your post and renaming the document and neither worked.

I wasn't clear in my post that I was saving as .xls instead of .ods because I have not yet been able to get any one else to try OO.o so I saved as .ods closed, opened then deleted the modules and saved the document. When I reopen the macros do not return so I then saved as .xls again replacing the original form and it is working again. No clue why this worked but this is the extent of my knowledge.

Thank you for the help.

[swingkyd]

Could the culprit be the settings in:

[Rod Carroll]

Thanks,
Changing the setting seems to have helped me with OO 3.0.1
_________________
Rod