View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
stebro stebro is offline
external usenet poster
 
Posts: 18
Default Need to defeat this security warning message


Thanks John for responding - this is a tough one. I did everything in the
link below offered as the proper way to remove vba code from the workbook...
<http://www.contextures.com/xlfaqMac.html
This site basically tells you how to go in and delete anything - even spaces
that makes it look like there is code in there - and in a couple of cases
modules to delete, but I don't think in my case I had to delete anything.

Also, I tried changing the macro security settings but that didn't work
either, and even if it did it still leaves the problem for someone else to
"discover" and it would look like I was passing something fishy off on them...

--Steve



"John Bundy" wrote:

Did you delete any modules that were created? This sometimes causes a
problem.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"stebro" wrote in message
...
I tried to use vba earlier to enhance a spreadsheet but it didn't work so I
deleted it. Now every time I try to save the worksheet I get the
following
message:

"Privacy Warning: This document contains macros, ActiveX controls, XML
expansion pack information, or web components. These may include personal
information that cannot be removed by the "Remove personal information
from
profile properties on save" option in the Security tab of the Options
dialog
box on the tools menu."

I followed the instructions here
<http://www.contextures.com/xlfaqMac.html
for removing all VBA code, but I still get the privacy warning. Is there
anything I can do to rid this spreadsheet of this "impending doom"
message?
I need to move this workbook into a production environment and people are
not
going to want to use it if it looks like their private information is
going
to be compromised.

Thanks - Steve