shrivallabha
12-30-2010, 08:18 AM
I have attached a file which has a small application built for ease of inputting and general status review. I added to ActiveX controls through Additional Controls option on VBE Controls Toolbar.
1. Calendar
2. Treeview (Courtesy: Ken Puls and Colo's website)
I thought I had tested it enough. We have a small group of friends where we share information. I sent the file to them. And one of the guys had this error:
Object Not Found.
The ActiveX Controls were NOT added on his toolbox. To my dismay and surprise, I could find TreeView Control in the library but Calendar Control was not at all available.
So my questions are:
1. For design time we need these controls added on the toolbar but when we are running the application i.e. at runtime, it is not necessary to have these controls added on user's toolbar. Am I right in this assumption?
2. We all use Excel 2003 (None of them is pirated). Is it possible that the control may or may not be present? What do I need to check?
And finally, this is purely pastime (only one thing: I've built this for my wife so that I could justify that I at least do something worthwhile on the PC). So I am ready to wait for all answers and suggestions. And I must say, all the help on this forum has been very good.
1. Calendar
2. Treeview (Courtesy: Ken Puls and Colo's website)
I thought I had tested it enough. We have a small group of friends where we share information. I sent the file to them. And one of the guys had this error:
Object Not Found.
The ActiveX Controls were NOT added on his toolbox. To my dismay and surprise, I could find TreeView Control in the library but Calendar Control was not at all available.
So my questions are:
1. For design time we need these controls added on the toolbar but when we are running the application i.e. at runtime, it is not necessary to have these controls added on user's toolbar. Am I right in this assumption?
2. We all use Excel 2003 (None of them is pirated). Is it possible that the control may or may not be present? What do I need to check?
And finally, this is purely pastime (only one thing: I've built this for my wife so that I could justify that I at least do something worthwhile on the PC). So I am ready to wait for all answers and suggestions. And I must say, all the help on this forum has been very good.