LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default VBA---Tools--References automatic

Good day everyone,

Is it possible through VBA in the Workbook open to add an instruction
in order to make sure that the "Microsoft Forms 2.0 Object Library" is
entered..

In the VBA window, you must click on Tools, then References and then
click on the "Microsoft Forms 2.0 Object Library"

I'd like this to be automated..... I tried:

Private Sub Workbook_Open()
VB(References("Microsoft Forms 2.0 Object Library")).Installed
= True

Does not work... Also played around with the paranthesis.... Did not
work either...

If someone knows, I would appreciate.

Thanks for your time

Denys

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tools | References AA2e72E Excel Programming 2 May 18th 06 10:28 AM
VBE ToolsReferences Bill Martin[_2_] Excel Programming 2 February 24th 06 01:17 AM
Tools...References shows "MISSING:" in front of 2 references Mike Jamesson Excel Programming 1 October 19th 05 06:33 PM
Tools>References greyed out Atchoum Excel Discussion (Misc queries) 3 March 4th 05 12:24 AM
Tools | References - information about references L Mehl Excel Programming 6 July 4th 04 06:28 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"