Strip workbook of macros, VBA, MS Query, etc.

[Guest]

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

 

[PCLIVE]

Press Alt-F11 to bring of the VB Editor.
If you see a Module folder, then expand it. Right-click on each module
listed and select Remove Module. Also double-click on each sheet listed on
the left pane and remove any code that may display in the right pane.
Repeat for "This Workbook"

HTH

 

[Guest]

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

 

[Bob Phillips]

See http://www.contextures.com/xlfaqMac.html#NoMacros

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Thank you Bob, PCLive, and bigwheel,

I followed your instructions and the message went away.

I appreciate your help!