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

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

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

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


"Paul Kraemer" wrote in message
...
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

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

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

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

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

--
HTH

Bob Phillips

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

"Paul Kraemer" wrote in message
...
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

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

Thank you Bob, PCLive, and bigwheel,

I followed your instructions and the message went away.

I appreciate your help!

--
Paul Kraemer


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Paul Kraemer" wrote in message
...
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