ActiveX warning after control is deleted

[david.j.winfield]

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

 

[Tom Ogilvy]

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

 

[david.j.winfield]

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.