View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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