Can anyone help me with this newbie question:
I need a macro that prints all tabs in a given workbook.  Can anyone
provide me the code please?
Thanks,

Can anyone advice how I change the font colour for footer text?  I'm wanting
to change it to grey so it's a little less obvious but can't figure out how
to do it.
Many thanks,

Let's say I wanted something to occur at specific times (via DDE) on Sunday,
a different thing on Monday -Tue, Wed, Thurs, Fri Sat and continue over and
over.
I see how I can know the day and time, but to use it in a formula escapes

My dear, please tell me ( with example) how to calculate values between
two dates .

I would like to write some smarter code to -
(a) initially hide columns C-I on Worksheets 1-3, then
(b) show only the columns selected by check boxes on each of those
Worksheets after pressing a button named 'SIB'.

I am using a scanner that reads barcodes and automatically enters data
into a cell. The problem is that I'm not always close to the computer
and want to have the cursor automatically go to the next cell after i
scan one code without having to press enter after every scan. Is there

I get the data from data warehouse.
I than input the data in Excel.
I have a list of accounts in column A.
In column B, C, D... are months from January to December, and then for

I have created an Order Form That has info in the first 16 rows pertinent to
'sold to', 'ship to', etc. - then there are 20 rows of empty cells to enter
items being ordered - then the bottom rows conatain 6 rows of info pertinent
to the order like tax, freight, totals, etc.

I am new to VBA as well as being new to this newsgroup. I am having a
problem trying to set a group of checkboxes to a common value (on clicking a
button). I expected the following code to work:
Private Sub CLRALL_Click()

Eg, I use following data to make a pivot table, the minimun order for product
A is 100 and I got total 23+45+70=138 pcs of product A on hand, So I should
order 200 (minimum multiple of 100 that larger than 138).
Product      Min_Order       Qty

I want my account number to be preceeded with zeros.  instead of
account number 2, I want 0002.  How can I customize the cell to do
that?

how would one express 1st Monday 3 months later?
given start date in a1 as 2007-06-11
adding 3  months is easy: =date(year(a10),month(a1)+3, day)
but how do I make sure if that is not Monday, I grab the coming Monday?

I am trying to run a macro which, among other things, copies
information to a cell 1 row down from the previous cell each time it
is run.
The column, in this case D, remains the same each time, but the row is

I'm working on trying to get a formula working faster and more
efficiently. Right now any change causes the workbook to lag heavily.
The source data is made up of
40561 records, each record is made up of 23 columns of information

I don't know what to call what I need to do, so I'll describe the situation.
If I type in 100800 in A1, how can cell display that number + 199 so that,
although I typed in 100800, the cell displays:
100800 - 100999?