Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

object library not registered

0

while using activex controls, error message:" object library not registered".

I am using office 365. how to register this object library or how to solve this issue. thank you

Answer
Discuss

Answers

0

In the VB Editor window (open with Alt+F11 from a worksheet), click on Tools > References. You will see a number of referenced object libraries checkmarked. You should find one or more items listed as "missing". These might be templates or add-ins which VBA can't find. In such cases it's often enough to remove the checkmark against them and see if the project can survive without them. 

On the other hand, if it's system DLLs that VBA can't find you may have to hunt them down on the Internet, download and install them. Or there might be something gone wrong with your installation (damage to the registry). Run "Repair installation" before taking bigger action.

Discuss

Discussion

Error accessing system registry!
in TOOLS/Refences: no listing, no check marked
nvthota Apr 30, '20 at 12:55 am
please let me know HOW DO I REPAIR INSTALLATION?
nvthota Apr 30, '20 at 12:58 am
From the Control Panel, select Programs > Programs & Features > Uninstall Programs. From there you can branch into "Turn Windows features on and off" which I believe has a side switch to repair Windows, and "Uninstall, change or repair programs", where you can repair the installation of applications like Excel.
Variatus (rep: 4889) Apr 30, '20 at 5:09 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login