hello! guys... isn't there anybody to discuss the problem and come up with atleast ideas to approach the solution?! regards.

hey, the entries are made perfectly fine.. my project is an excel addin(thus, entries are made in hklm\software\microsoft\office\excel\addins\) not a visual studio addin. Basically, my Connect.cs also defines some UDFs and also adds a command bar to the excel. The commandbar is being displayed properly in the test machine but the automation part i.e., the UDFs are not being recognized. What could be the reason for the automation part of my addin not to work when the com part is working fine?! Regards

hey Graus, good to see you replying. Well, at last i figured out and it has made the registry entries in 'hkey classes root' on the test machine.. but apparently am very surprised with the fact that, though I am not able to see MySample.Connect in 'Excel--Tools--Addins', my addin is working to some extent. Actually my addin is supposed to generate a button in excel, on the addin-created CommandBar(which i call MyCommandBar). The button is showing up and all the forms resulting its click are showing up. however, the UDFs i defined in 'MySample.Connect.cs' are not being recognised!!! Why is this happening?! How am I able to see the button when there is no entry of 'MySample.Connect' in the 'Excel--Tools--Addins' list!!?? I need my UDFs to be working. Regards.

I'm no expert on Excel-interop, but I'm sure that some of those hang round here. In the meantime, there are two interesting events in that same documentation; - BeforeSave I guess this one is also fired if the user chooses "Yes", but not if he chooses "Cancel" or "No". - ShutDown Signals that the application is about to shut down. Perhaps you could do the same with a FileSystemWatcher, watching all the XLS-files in the specified directories for updates. Anyone else any idea's? I are troll :)

I would assume that the c# DLL can get access to the user.applicationdata folder so you should be able to store the number in there. Add enough 0 so you can not reasonably run out. Not sure an xl add in has that access though. Never underestimate the power of human stupidity RAH

oh, no one responded yet, anywayz, i got it myself... here's what i've done: string []s = selectedRange.Split(new char[]{':'}); Range res = ((Worksheet)MyApplication.ActiveSheet).get_Range(s[0], s[1]); Regards.

I also heard they were already supported in the .NET 2.0 CLR, but for some reason the features were not exposed to the C# language.

i already have my project developed as a new project--> extensibility--> visual studio add-in I want to build an MSI of this existing project. Am sorry but, did you mean I should create a new project which is a setup and deployement project? thank you.

Hey, i did google but still not able to understand why am I not able to do it. Also, I have a doubt, if am doing some thing like this(code below) in a normal project(not an excel addin),this is working fine: emp[] e = { new emp(1,"Mark",5000), new emp(2,"Mich",6000), new emp ( 3, "Amol", 4460 ), new emp ( 4, "Anil", 9456 ), new emp ( 5, "Srikanth", 9500 ), }; //SERIALIZING PART Stream s = File.Open("c:\\New Folder\\emp.txt", FileMode.Create,FileAccess.ReadWrite); BinaryFormatter b = new BinaryFormatter(); b.Serialize(s, e); s.Close(); //DESERIALIZING PART s = File.Open("c:\\New Folder\\emp.txt", FileMode.Open, FileAccess.ReadWrite); emp[] ee = (emp[])b.Deserialize(s); foreach (emp ez in ee) MessageBox.Show(ez.ToString()); s.Close(); But, the same is not working when am introducing this piece of code in my excel-addin project. What could be the reason for this behavour?! Thanks.

this is can change simply. first you must change the property DropDownHeight (Default value 106 you can change to 100) and then reset it again(to 106). then you can change the value in maxDropDownItems = 10 or your value. it's work great.......!!!!!!!! thanks gihan gihan_chandima@yahoo.com

abhiram_nayan wrote: can yu give me d code to show d button Hell no. Don't ask for code, and for the love of everything holy STOP USING TEXT SPEAK

All cells, by default, have Protection turned on. You have to specifically unprotect the cells you went to remain active when the sheet protection is turned on. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008