Deleting all macros still results in Run Macro dialog box?

[rcpao]

I created a macro for a spreadsheet. It did not work as intended so I permanently deleted i. The macro editor shows Standard -> Module1, but it is empty.

Now, because I did not specify the directory as safe to run all macros, I get a dialog box asking if it is safe to run macros in this spreadsheet. When there are macros in the spreadsheet, I expect to be asked. When there are no macros, I do not.

How do I make the dialog box go away for this file in whatever directory it exists in? Allowing the current directory to always run macros is not an option for my purposes.

rp050203

[DiGro]

rpao,

you have to delete the Module1-library.

go to Macros and select the Module1
Click the Manage-button, which will give you the option to delete Module1.

When it is deleted you will no more be prompted for the macro's

DiGro