Warning in .xlsm file

J

JeffC

Hi - I have a workbook (.xlsm) that keeps giving me the following message:

Privacy warning: This document contains macros, ActivX controls, XML
expansion pack information, or Web components. These may include personal
information that cannot be removed by the Document Inspector. [OK] [Cancel]

How do I get rid of this thing? I've already made the workbook an .xlsm - I
KNOW it's got macros in it, and this message re-occurs about every 5 to 10
minutes regardless of which button I choose.

Thanks in advance.
 
J

JLGWhiz

This from FreeBee2:

press Developer; Macro Security; Privacy options; Document-Pacific settings,
untic the box for "Remove Personal Information from file properties on Save"
and press ok to exit.
 

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