I need cell "H1" to display a fixed time and date on open of the workbook.
Then when workbook is saved, this date and time remains static. Can this be
done?

I have inserted a listbox in a w/book,this w/book has no macros.Whenever I am
opening this w/book  a message box 'this w/book contains macros
enable,disable'
is poping up.As I know my w/book has no macros,I opted for 'disable

Help please . . .
I have a macro that I've assigned to a button on a  worksheet. I've
protected the VBA code and I only want the users to be able to run the
macro from my button.

I am in a situation where all my cells on one worksheet(say 2) are
updated according to the cells in other worksheet (say 1).
Though all the formulas in 2 are calculated with the values in 1. I
also need to update it based ont he formatting of the cell in 1.

Hope I can get a bit of help on this, we have about 2000 rows and 50 or
so cells in our row that have formulas that have "(INDIRECT(T$1&
"$AB6") in them, as an example.  The problem is we'd like to
filldown but the "$AB6" part of it will not change to "$AB7",

I am trying to create a simple list in a cell:  YES or NO.  Then I want to
sum the row of YES or NO's.  If I can assign a value of 1 to YES and 0 to NO
I can do the math.  Not sure how to assign a numeric value to a short list of
text in a cell to enable this math operation.

I have the following macro doing a filldown and it works perfectly.
Dim a As Long
a = Range("B" & Rows.Count).End(xlUp).row
Range("C6:BQ" & a).FillDown

I have run into a problem where my excel charts no longer autoupdate.
I am not sure if it is because of macros I have written, but I doubt
it.  When I update a cell from, say, 20 to 30, the chart does not
automatically update.  The only way to see changes in the chart is to

Format column to be x characters wide.

What formula, if any, would return, say, "true" or "false", for the presence
of the strikethrough effect on text in a given cell?

my excel help identifies this function, but the actual use of it returns the
?name error.
Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion

I get unexpected results when date formatting a worksheet cell in a MS Excel
spreadsheet  - in other words it looks like a calculation is trying to take
place such that entering 1220 in the cell returns a date of 5/4/1903 and
entering 12202006 0r 122006 returns a negative date ...

I have two Excel spreadsheets. On one of them i have two collumns that
contains a range of number. Like in cell A1 there is the number 2470000
and in the cell B1 there is 2470099. On the second spreadsheet,  there
is 2470000 in the cell A1 and 2479999 in cell B1. What i need to do ...

How do I get all of the formulas in the rows above and below the row that I
am inserting to automatically copy to the inserted row?

I have a bunch of numbers, lets say A, B, C, D. Each number is made up of a
combination of other numbers, lets say 1, 2, 5 make up A, 3, 7, 8, 9 make up
B and so on.
Is there any way I can get an output saying A is made up 1, 2 and 5 in