Search results for query: *

Ok, I finally got it to work. Thank you so much for your help.

SkipVought, Thanks for the post. The only problem with approaching it this way is that I have about 100 columns with different conditional formatting built into them. They can leave a cell alone, make it red, or make it yellow. My add-in has to behave differently for each of these. Since...

I have an Excel Add-in in which I need to be able to tell if a cell background color has been modified due to conditional formatting. I thought that I could check the value of "Application.Worksheets(sheet).Cells(Row, column).Interior.ColorIndex" but the value for this always stays at...

I have an Excel Add-in in which I need to be able to tell if a cell background color has been modified due to conditional formatting. I thought that I could check the value of "Application.Worksheets(sheet).Cells(Row, column).Interior.ColorIndex" but the value for this always stays at...

Works like a charm. Thank you so much for your help.

this does look like fun, even better though is the fact that i actually am using 97. before i get in over my head, what type of modifications would be required?

this works great, but is there a way to specify a default folder?

I need to display a dialog box that allows the user to choose where to place a new document. A normal common dialog box won't work because it gives them the ability to select a file. Does anyone know how to show only the folders?

Thanks, I used a combination of these suggestions and its working now.

I have a loop that runs through and updates excel sheets. The form that calls this process has a cancel button on it, but it is useless because the click events are ignored while the loop is running. Any ideas how I can make the cancel button work? Btw, I have already used DoEvents to set the...