I selected 'Remove personal information from file properties on save.'

I am now receiving a message that informs me that the WB has macros, and
personal information may be contained within them that cannot be removed.

How can I prevent this message from being displayed?

Hi John,
Once you have macros in a workbook you have to get rid of the module,
deleting the code is not sufficient. Deleting the code only is sufficient
for sheets and thisworkbook. For mmore information and a macro to
remove see Chip Pearson's
http://www.cpearson.com/excel/vbe.htm near bottom look for
Deleting All VBA Code In A Project
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PosseJohn" wrote in message ...
I selected 'Remove personal information from file properties on save.'

I am now receiving a message that informs me that the WB has macros, and
personal information may be contained within them that cannot be removed.

How can I prevent this message from being displayed?

This link you provided was not valid, could you check it please.

"David McRitchie" wrote:

Hi John,
Once you have macros in a workbook you have to get rid of the module,
deleting the code is not sufficient. Deleting the code only is sufficient
for sheets and thisworkbook. For mmore information and a macro to
remove see Chip Pearson's
http://www.cpearson.com/excel/vbe.htm near bottom look for
Deleting All VBA Code In A Project
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PosseJohn" wrote in message ...
I selected 'Remove personal information from file properties on save.'

I am now receiving a message that informs me that the WB has macros, and
personal information may be contained within them that cannot be removed.

How can I prevent this message from being displayed?

I have only worksheet code included, the message still comes up.

"David McRitchie" wrote:

Hi John,
Once you have macros in a workbook you have to get rid of the module,
deleting the code is not sufficient. Deleting the code only is sufficient
for sheets and thisworkbook. For mmore information and a macro to
remove see Chip Pearson's
http://www.cpearson.com/excel/vbe.htm near bottom look for
Deleting All VBA Code In A Project
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PosseJohn" wrote in message ...
I selected 'Remove personal information from file properties on save.'

I am now receiving a message that informs me that the WB has macros, and
personal information may be contained within them that cannot be removed.

How can I prevent this message from being displayed?

I clicked on the link I gave you from within your reply and it worked fine for me. Suggest you
use the macro because that is much more reliable than trying to do this
manually.


"PosseJohn" wrote in message ...
This link you provided was not valid, could you check it please.

"David McRitchie" wrote:

Hi John,
Once you have macros in a workbook you have to get rid of the module,
deleting the code is not sufficient. Deleting the code only is sufficient
for sheets and thisworkbook. For mmore information and a macro to
remove see Chip Pearson's
http://www.cpearson.com/excel/vbe.htm near bottom look for
Deleting All VBA Code In A Project
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PosseJohn" wrote in message ...
I selected 'Remove personal information from file properties on save.'

I am now receiving a message that informs me that the WB has macros, and
personal information may be contained within them that cannot be removed.

How can I prevent this message from being displayed?