I put an ActiveX control on a sheet by accident, and I deleted it and
I still get an error every time the worksheet is opened about enabling
ActiveX.

Is there a way to remove all traces of an ActiveX object so the error
does not keep coming up? I do not want to change my security
settings, because I have to send this file to other people and I do
not what everyone to keep having to press ok or change their security
settings.

Thank you,
David

You can try Rob Bovey's code cleaner - it might help:

http://www.appspro.com

look under free utilities or directly
http://www.appspro.com/Utilities/CodeCleaner.htm

--
Regards,
Tom Ogilvy


"(E-Mail Removed)" wrote:

> I put an ActiveX control on a sheet by accident, and I deleted it and
> I still get an error every time the worksheet is opened about enabling
> ActiveX.
>
> Is there a way to remove all traces of an ActiveX object so the error
> does not keep coming up? I do not want to change my security
> settings, because I have to send this file to other people and I do
> not what everyone to keep having to press ok or change their security
> settings.
>
> Thank you,
> David
>
>

Thanks for your help. I actually found that I had missed one of the
controls that I added. Once that was deleted it stopped giving me the
error.

This seems like an interesting application, I'll have to keep it in
mind for cleaning up my VBA.

On Aug 29, 9:30 am, Tom Ogilvy <TomOgi...@discussions.microsoft.com>
wrote:
> You can try Rob Bovey's code cleaner - it might help:
>
> http://www.appspro.com
>
> look under free utilities or directlyhttp://www.appspro.com/Utilities/CodeCleaner.htm
>
> --
> Regards,
> Tom Ogilvy
>
> "david.j.winfi...@gmail.com" wrote:
> > I put an ActiveX control on a sheet by accident, and I deleted it and
> > I still get an error every time the worksheet is opened about enabling
> > ActiveX.
>
> > Is there a way to remove all traces of an ActiveX object so the error
> > does not keep coming up? I do not want to change my security
> > settings, because I have to send this file to other people and I do
> > not what everyone to keep having to press ok or change their security
> > settings.
>
> > Thank you,
> > David