Removal of Private Information

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" <PosseJohn@discussions.microsoft.com> wrote in message news:7B70104A-3074-44D3-B093-F2C2CAA00DA8@microsoft.com...
> 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" <PosseJohn@discussions.microsoft.com> wrote in message news:7B70104A-3074-44D3-B093-F2C2CAA00DA8@microsoft.com...
> > 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" <PosseJohn@discussions.microsoft.com> wrote in message news:9A748D3F-7C2C-40A5-A336-A3098B5366F0@microsoft.com...
> 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" <PosseJohn@discussions.microsoft.com> wrote in message news:7B70104A-3074-44D3-B093-F2C2CAA00DA8@microsoft.com...
> > > 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" <PosseJohn@discussions.microsoft.com> wrote in message news:7B70104A-3074-44D3-B093-F2C2CAA00DA8@microsoft.com...
> > 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?
>
>
>