how i get more no of worksheets at a time please explain briefly

I was wondering how to activate a waiting message to pop up while one of my
longer macros is running, so that the users do not think the program froze. I
was given one VBA code, but I couldnt get it to work. Thank you.

As part of a macro, I'd like to be able to identify and re-format only cells
containing words in all caps. Is that doable?
Thanks!

I had a 3 page document in excel 2000 and went to work and opened it in excel
2003, now I can not open it on my home computer with the 2000 version, is
there anything that can be done to get it back or is it gone and stuck in
version 2003?

I want to add all cells that have a certain color of shading. For example, in
one cell, give me the sum of all cells with red shading. In another cell,
give me the sum of all cells with blue shading. This is so straightforward
that Excel must be capable of doing it, but how to ...

I have a cell (D11) validated to a list named Jnl that has two choices , Job
& Ledger.
When Ledger is selected in D11, cell E11 validates to a list of several
codes named LedgerList.  When Job is selected from the validation list D11,

I need a possible solution.
I am a mobile dj and have a database created in excel of my entire cd
collection it goes like this...
Artist - Song - Cd Title - Duration - Cat No.

Someone asked me to prepare a sheet with a large number of check boxes. When
I try to copy the check box the reference field (even if it is a relative
reference) gets copied as well. This means that if I copied the checkbox
twice, all three checkboxes alter the same reference ...

How do I locate the file which stores Excel Macros?  My PC hard drive was
removed and placed as a secondary drive into another PC.  I'm now using a new
PC that has Excel but not my original custom macros.  I need to locate and
copy the file which stored the macros that I used ...

I am running some code to loop through files.  I want to pass the file name
being examined to a textbox on a userform.  I am not familiar with
referencing these objects in Excel VBA.. rather easy but different in Access.
Can any one help?

I need to print 53 Excel worksheets 50 of which will have multiple printed
pages and I need each printed page to display column headings by repeat
printing rows 1 through 11 for each of the 50 worksheet. How can I set the
print title "rows to repeat at top" for all 50 worksheets ...

What would cause the following to happen?
When you click on Window -- you see a listing for the name of the
spreadsheet.xls:1 and then name of the spreadsheet.xls:2
Trying to make that stop and just have one file.

I run an AutoFilter in a macro, and i was wondering if there was way to hide
or remove the grey button that appears in the worksheet ?

In this example assume:
A1 never had a value and is blank
Cell B1 contains the formula =if(a1=0,"",a1) and should result in ""
Rows D and E are as follows

Why does this not work?
Range("D & LastRow - 3:I & Lastrow - 3").Style = "Comma"
I want to format this range underneath a table, of which the length
varies.