How to find & remove unneeded activex control

**gjcase** · 04-01-2011, 03:53 PM

I have a spreadsheet with a set of macros. One of the macros used the Microsoft Calendar Control 11 to furnish a popup calendar. However, I have disable this by erasing the page code which referenced the control.

I have given a copy of the spreadsheet to a coworker. Everything worked fine until she got Office 2010, at which point the macros quit working with the error message "Unable to find project or library." Using the VBA References dialog box, I have traced this issue to the fact that the Office 2010 installation on her computer does not have the Calendar Control 11 file. I went into the References dialog & tried to uncheck Microsoft Calendar Control 11, but I get an error message telling me it can't be deleted because it's in use. I've looked through my other macros & can find no references to it. The help box on the error message says to remove the control from the form & then uncheck the box. There are no forms listed in the project window.

Can someone tell me how to find where this may be so I can delete it? While we could just install the control file on her computer, I'd really prefer to clean up the spreadsheet so I don't keep running into this every time I provide a copy to someone.

Any help appreciated.

---GJ Case

**Leith Ross** · 04-01-2011, 05:57 PM

Hello gjcase,

While you removed the control, presumably from the worksheet, did you also remove any event code fragments on the worksheet it was attached to? If you still can't find the problem, post the workbook so it can be reviewed.

**gjcase** · 04-04-2011, 10:31 AM

Leith:

I'm fairly certain I have done so, but it's a good suggestion. I may try selectively deleting Modules on a copy of the spreadsheet until the issues goes away... Is it possible there's a form still out there which would not show up in the project window?

GJC

**gjcase** · 04-04-2011, 11:24 AM

Okay, I narrowed this down to one sheet. If I delete the sheet, the Calendar Control no longer shows up on the Reference list. However, I can't find where it is used.

I copied the spreadsheet and deleted all other sheets, all modules, all objects on the sheet, the page code, and finally all the data on the sheet. No luck.

I'm attaching the now-blank file. If anyone can figure out where the Calendar Control is used, I would appreciate knowing where it is. I really don't want to reconstruct the sheet to correct this issue.

GJC

**jwright650** · 04-04-2011, 11:33 AM

Calendar1 is listed in the pull down menu in the VBA editor for that sheet. Not sure how to delete it out though.

**gjcase** · 04-04-2011, 12:21 PM

Thanks for the response! I just found that & deleted it using Sheet6.Calendar1.Cut.

GJC

**Mony** · 09-17-2012, 11:52 AM

Any suggestion for me? I am also has same problem like you, but your fix doesn't work for me

any help with that activex control? Something like videocap ?

**arlu1201** · 09-17-2012, 12:00 PM

Mony,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.