Recent content by gusset

thanks, IvanMoala, for both tips. i ought to have got the second one myself though! btw, i notice that the location changes according to the platform. on this (xp) machine (with Office XP), the path is "C:\Program Files\Microsoft Office\Office10". i wonder whether there is a way to...

my add-in sets the application icon to an icon of my choosing when it runs, as per the following standard code. i have two questions: 1. the icon change works for the application in the top-left part of the application window and for the small window which appears when the Excel taskbar button...

KornGeek, just wanted to say that your solution was very elegant and i wish that i had thought of that! best wishes gusset

sorry, you're right - for each obj in collection (not collection.count). i was indeed talking about debugging, but the question is equally applicable for an exiting condition. the answer is the .index property, which i had forgotten about completely. why is it faster? thanks gusset

by the way, i know i could increment a variable. but is there some other way? g

i follow the advice to use the following syntax: for each obj in collection.count ... next obj rather than for i = 0 to collection.count -1 ... next i because it is said to be quicker. but if, with the first syntax, i stop code execution part-way through the loop, how can i examine which...

excellent, thanks v much... ...now how do i remove an add-in programmatically? if this is possible, how do i remove the very add-in containing the code to remove the add-in? what i am trying to do is this: let the user run the code behind the add-in somehow. i don't know the standard way to do...

thanks, PhillipAyres. i'll try that now! gusset

this thread has been closed for a while, but i'm trying to create an add-in which is to be available to all my colleagues in the global template the add-in will contain code that is currently in the modules of an existing spreadsheet. the way i want it to work is that the code will run when a...

i think it will ("Attach Custom Toolbars to Microsoft Excel Workbooks and Templates"). thanks, BenRowe. best wishes gusset

there would be no problem if i wanted it on the sheet! do you say it can't be done? gusset

thanks, but the button stays on the toolbar if i close the workbook or open another! gusset

great faq! i got the same tip from wrox's Excel 2000 VBA - they must have read your faq too! gusset

i have a workbook which some of my team will use. i'd like that workbook to have a button on a toolbar which runs a macro in that workbook. but i don't want the button (or the toolbar) to appear with other workbooks. i'm not familiar enough with the excel interface to know how to achieve...

Correct! thanks very much. i should have thought of that myself gusset