Sounds like the macro has been removed but the module it was in remains.
Open the Visual Basic Editor (Alt+F11) and see if there is a module attached
to the file. If so, right-click it and select Remove Module

"Paul Kraemer" wrote:

Hi,

I have a workbook that someone else created. When I open it up, I get a
message saying macros are disabled because the security level is high and the
macros are not signed. When I go to Tools | Macros, there are no macros
listed. I have also deleted all the VBA that I could. I have also removed
all of the references to MS Query that were originally used on the workbook
(although these were not very easy to find).

I am guessing that I have missed something and that is why I am getting the
message when I open the workbook. I was just wondering if there is a way
that I can forcibly strip a workbook of all macros, VBA, MS Query references,
etc. I just want a dumb workbook with just data.

Thanks,
Paul
--
Paul Kraemer