Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to do a web query on an web browser on an user form using macros | Links and Linking in Excel | |||
Print All Excel Macros Contained in a Workbook | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Sharing workbook with macros | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) |