Need to defeat this security warning message

S

stebro

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
 
J

John Bundy

Is there anyway you can just copy all of those sheets to a different
workbook? I've never had to but it should not come up after that, just
select all sheets, right click, Move or copy, select a new workbook and
check the create copy box. Sorry if you already knew that. Let me know if
that fixes it.
 
D

Debra Dalgleish

Choose Tools>Options
On the Security tab, remove the check mark from 'Remove personal
information from file properties on save'
Click OK
 
D

Debra Dalgleish

Hi Steve,

The Privacy message is created by a workbook setting, so shouldn't be
affected by settings on the users' machines. It's different than the
Security warning that's displayed based on a user's security setting.

The Privacy message seems to be triggered even if you open the Visual
Basic Explorer, without creating a macro. Once the message has been
triggered, I don't know of any way to remove it from the workbook, aside
from turning off that 'Remove personal information' option.

Debra
 
D

Debra Dalgleish

Unless it's company policy that you leave that Privacy setting turned
on, I'd turn it off. Then users won't see any alarming messages, and
won't be worried about your workbook.

There's a bit more information in the following MSKB articles:

OFFXP: "Remove Personal Information from This File on Save" May Not Work
with Macros
http://support.microsoft.com/kb/286394

How to minimize metadata in Microsoft Excel workbooks
http://support.microsoft.com/kb/223789
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top