I am using pivot tables with drill down enabled.  Is there a way to modify
how the drill down reports generate?

I am starting to port the Spreadsheet Detective to Excel 2007 Beta 2,
and it has been a painful experience.  For the first time since Excel
95, the new version will not simply run the previous add-in.
I had in fact kept the add-in compatible with Excel 95 & and simply

I have a problem in my workbook that the cells  will not accept the three
text digits of ACN but instead changes it to CAN.What could cause this to
happen?

how do you create custom buttons in office 2007?

I'm hoping someone can help me........... I want to be able to
open a workbook trigger a macro that will copy a spcific sheet titled "Tasks"
in its entirity and open it in another workbook overwriting any "Tasks"
sheet that was there.   Thank you to anyone who helps.

Here is the code and I am getting a compile error...
any ideas?
For a = Dates.Count To 0 Step -1
       DTadj(a) = Application.WorksheetFunction.workday(Dates(a), 1,

I've hacked at this for a while and can't figure it out. I really need
it for an office project.
What formula do I use for Column C, when:
There are numbers in Column A, but not in all of the cells in that

I am using the Forms toolbar and am buidling click event macros.
Does anyone have a list of object "names" as called in the two sample VB
lines below?
Specifically, right now I need this for the DropDown combo box. But I would

I've read that this happens when there is a function like NOW(),
TODAY(), etc...
However, I am still getting the save changes prompt on a variety of
workbooks despite not having any of these functions.  What they do all

Can a hit counter be programed into the Excel file? I know you can do it
under a web page but I would like the counter to be in the file itself.
Thanks.

There seems to be two different color index schemes in Excel, on for
the cells and one for the shapes.  So one cannot write code like
MyCell.interior.colorIndex = MyShape.Fill.ForeColor.SchemaColor
Is there any clean way to convert one to the other?  I need the same

I have a button on a worksheet that the user clicks after entering data in a
couple of cells, the problem is the button will not work until the user
clicks out of a cell they are supposed to input data in.
I have all the cells locked except the cells I want them to enter info into ...

...this may already be common knowledge, but in case it is not, there is a
curious bug in the properties window for the Active X control button.  While
changing the color of the background, a pop-up appears with two tabs.  One
reveals the "system colors" the other should display ...

When running macros in Excel 7.0 that were built in Excel 2003, the status
bar messages do not display.  Status bar messages are critical when
troubleshooting new macros or when troubleshooting macros that do not work as
well in Excel 2007 as they did in previous Excel versions.

For i = Dates.Count To 1 Step -1
       DTadj(i) = (Application.Run.WORKDAY(Dates(i), 1, Holidays)) - Dates(i)
Next
why doesn't workday function run?