Hi,
At some point some vb code will work fine if related Reference VBA Project was already tick on the list.
So far I did it manually by selecting Tools-References and Tick on which one I need (on VBA code window)

My question is: Is there any macro which can replace my manual work for doing the same task?
for example I want to switch on the next three Reference VBA:
1. OLE Automation
2. Microsoft Office 15.0 Object Library
3. Microsoft HTML Object Library

It is something like , go and check if the XXXXX Reference VBA is not available the make it available, if already on then perform the next task.
just for additional info, I am using excel 2013.

Regards,
Benny