When is it correct to declare a sub Public vs Private? What is the advantage?

My macro opens a series of files (approx 32) and copies information from them
into the main file, closing the file with the information each time. The
macro works OK, except each time it closes a file it requires manual
intervention- asking if I want to empty the clipboard of the ...

I have a worksheet where I would like the users to be able to use Trace
Dependents. However, when I protect the worksheet this is no longer possible.
So I was was wondering whether it is possible to create a macro which allow
you to use Trace Dependents when a worksheet is ...

I hope there is someone who can help me solve a problem.
I have a database sheet in excel called "datadga"
I have a userform on which i have a multipage object with a lot of text
boxes and comboboxes.

I have a combobox with 8 people names. I have it linked to cell D6. It
works fine except when I click the 3rd name, lets say Tom, cell D6
shows up as 3, name 6 Maria shows up as 6 instead of Maria. How do I
get D6 to match whatever name is selected in the combo box?

Hi all I have some Data in Coloum K I have Payment amount. I want to Search
this and find the higest amount. Then whatever filed the higest amount is in
go across to coloum c and take the value of that field I have some idea how
it may go but just wanted to get better idear any ...

How do I avoid this question:
Do you wish to replace the contents of the destination cells in Pivot Table?

I have figured out how to have Excel create a directory and save a CSV
of the current workbook.
Now the macro hangs if the directory already exists.  How do I check
for the directory and create only if needed.

I am trying to replace a cell I2 with a cell H2's contents if cell I2 is
equal to the letter a.  NOTE:  The cell has the letter a preceeded by the
single quote:  'a  
It, the single quote, of course is not visible, but when you look in the

What is wrong with this?
If locale = "P" Then Selection.Interior.ColorIndex = 3 Else: If locale = "L"
Then _
Selection.Interior.ColorIndex = 6 Else: Selection.Interior.ColorIndex = 9

I am looking to build a function that does the opposite of a union function.  
Put it in a loop that randomly draws a cell from a pre-defined range.  And
redefine what that range would look like after the draw.
So for example lets say my pre-defined address is A1:Z400.  I want the

In a normal Sub in a normal module (not run via automation) I have this line
of code:
Columns(8).NumberFormat = "@"
Actually it is:

I have vba code in excel that calls on some functions of Word.
I am using Office 2003 but my users are using either 2002 or 2003.
When I add the reference from the vba editor, I am able to choose:
Microsoft Word 11.0 Object Library (from my machine)

I am a intermediate user of Excel.  I don't know if this is possible but this
is what I would like to do.  I am going to a trade show that particpants will
come to our booth and be able to register for a prize.  They will only be
able to enter once.  But over the course of the 3 ...

I have a an excel document that was created by someone that no longer works
at my company.  It has drop down menus that I need to modify and do not know
how.  Also when any selections in the drop down menu are selected the work
next to the one I'm working in changes to the ...