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.

I don't have xl2007 but it sounds like a security level setting might be
involved.


"JeffC" wrote in message
...
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.

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.




"JeffC" wrote in message
...
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.

That did it! Thanks both for your answer and persistence! Jeff