I am very new to macros, but I have written several and mapped them to
buttons.  I have seen some sample code that is triggered when the user saves,
or doubleclicking etc.  Does anybody have a good reference on how to do this,
and what can be triggered?

I want to write a macro by which I can change the date format fo
dd/mm/yyyy to mm/dd/yyyy.
How to do this
--

I have MS Excel installed on a system at work. There is one file which is a
shared workbook. Whenever I try to open Excel directly - either using the
shortcut or from the Start menu, this shared workbook and all other recent
files cascade and open up. Is there any way to default ...

It seems pretty easy to add a page break, but I'm trying to find the rows
where a horizontal page break exists.  I've been trying use something ilke
the following to loop through them and see their location
For x = 1 To Worksheets(1).HPageBreaks.Count

The below macro works just fine when the worksheet is not hidden.  But
when it is the macro bombs out.
Sub Button11_Click()
Sheets("Print Ticket").Select

Hi there and thanks in advance for any help you can give me . . .
I am currently daily manually logging daily historical prices into an excel
worksheet.
I would like to make a macro that daily takes the values (only) from a

I have a automated process set up in an excel template.  The porcess takes
info from one sheet and puts associated information into another, based on a
cell reference.  I need the process to repeat over and over, until all the
cells have been referenced.  Can someone tell me how ...

I have added the:
"Adobe Acrobat 7.0 Type Library"
under tools and references.
This is the only Adobe Product I have in my PC.

Is there anyway I can disable cell resizing or unmerging of cells, while
leaving the cell/merged cells unprotected. The reason I need the cells/merged
cells to be unprotected is because I'm making a form where the user will need
to type text on specific cells. I want them to be ...

Probably a simple answer to this, but I am doing a find using the
Range.Find function.
It is looking in all cells.  Goal is to get column A's value for the
row that my string was found.  How can I do this?

What I want to be able to do with a macro is the following.
Once you click the “Save” button:
Save the file to the c: drive  (I have no problem this is part)
Save the file to the thumb drive.  

currently, name of loaded userform ??
my mean, not caption but name ...

I need, in a macro, an instruction that will display a long list fro
which the user can select an item and paste it into the current Activ
Cell.
For approaching the item wanted I envisage one of those boxes with

Basic Question: How can I create a macro that tests whether the value in
column C is “X” and if it is, run a separate macro.  
Detailed Question:  At the moment, I have a macro that names the workbook
after a date value in Sheet1!A1.  I want my macro to take that value and

Im  using:
Range(Cells(Range("b:b").find("e0").Row, 1), _
Cells(Range("b:b").find("e1").Row - 1, 1)).Columns("A:z").Select
to select all the rows containing 'EO' then sorting the data with