I am having real trouble with 'Workbook_BeforeClose'.  I have read numerous
threads and the help in VB, but nothing I try makes the event work.  I am now
so confused I'm stumped.
Can someone give me a step by step guide to what I need to do for this to

I have the following code to retrieve the next upcoming action. The
code works fine and does exactly what I want. However, I have lots of
projects listed in columns and want this formula to be listed under
each project.

Hello,
Is that possible to do this:
When the cell is selected, it will highlight with a color, when is not
selected, the color back to normal?

Good morning,
I am using WIN XP SP2 and Excel 2007
Microsoft explains in kb274680 (in french) how to retrieve procedures and
functions names of projects, but the method uses C++, which I do not have.

Hi,
here's the problem.
I have worksheets containing the same kind of data and would like to
consolidate data from the sheet with some restrictions. And I would like

I dont find the
button in the English Version Excel when I will fix the headline, so that I
can see this all the time when I scroll down or up.

Is there a a way to disable the usage of, or change the function of,
right-click Paste, Edit=>Paste and the Menu Bar Paste button to restrict
users to only be able to enter values and/or paste values into a sheet to
avoid changing existing formatting?

Tom Ogilvy kindly helps me with the code to evalute for a report. I now have
a new related problem.
In the following code, the first case statement works, but when I select the
second, if fails with runtime error 424. In debug, it highlights the line

I select the customer from a ListBox (Lb1) all the address data etc, enters
the Text Boxes OK. the ListBox is populated via RowSource. The ComboBox (Cb1)
is populated via "Add Item" on UserForm Initialize select an item from Cb1
and Tb6 and Tb7 fill Ok and can be entered on the ...

This is off-topic, but I'd like to look into getting certified as an MS MVP
in Excel.  Anyone willing to offer any tips?  Thanks, James

What is the most efficient way to determine if any of the characters of a
string are digits?  
One example would be a function that returns "TRUE" if one or more
characters of its single argument are digits and "FALSE" otherwise.

I have a workbook that saves a file with the following code:
Function DoesPathExist(myPath As String) As Boolean
   Dim TestStr As String
   If Right(myPath, 1) <> "\" Then

When I start excel 2003 SP2 with a blank workbook, and go Tools/Add-
ins...  a message is displayed saying "Unable to read file."  I
actually get this message three times in succession.  After which the
Add-ins dialog is displayed as if nothing were wrong.

I need to execute an FTP program and return directory information from the
ftp'd computer so I can manipulate it in VBA.  I know how to write a batch
file to start the program and the file the batch file starts.
What I don't know is how to start the process in VB so I get the ...

I have an Excel worksheet that has some rows that sometimes do not need to
appear in a print out (for instance if a specific column has a "NO" in it). I
could perhaps make the text same color as background (is there a better
technique to not print that text?) but the rows in the ...