For the life of me, I cannot get this to work; either it keeps looping,
doesn't return the right message, or bombs out.  All I'm trying to do is  ask
the user to input a date in mm/dd/yy format.  
1) If they hit cancel or don't enter anything, then they should get a

My spreadsheet is long and thin so only need to think about horizontal page
breaks.
I want to say fit to X pages vertically with the pages breaks here, here and
here.

New to excel and have no idea of how to proceed, any help or pointers
would be greatly appreciated.
I have a column of Names, with multiple instances of each name, and I
need to find out how many entries there are for each name. This column

I removed the one function I tested in my workbook, but Excel still
prompts with the VBA security box when I open the file.  How do I get
rid of this?
TIA,

  Is there any relatively straightforward way to implement an RPC mechanism
so that, for example, a procedure in MS Project can trigger a procedure in
MS Excel? Is there a data passing mechanism as well?
-Greg

Hi all, i as kindly given the code below by Tom Ogilvy but when i try to
run it i get Runtime 1004: Unable to get the dropdowns property of the
worksheet class, any ideas what is causing this?, the line in blue is
where the code stops and gives the error.

in cell A1, I have a formula:
   =IF(INDIRECT("'Time Line'!a"&ROW())=0,"",INDIRECT("'Time
Line'!a"&ROW()))
How would I check for this condition in code?

We share an excel file and very often while saving, it crashes. It's three
of us that are using the file. The file is on the network, mapped drive.
There are also many external links.
What can the cause for crashing be? The mapped drive maybe, or something

I have the following loop in a function to get rid of unprintable
chararcters (car ret, line feeds, etc) in a cell.
It works fine most of the time, but something is getting by it.
I keep running into a cell that has one char that always remain (I can

Blah blah

hi,
how can make ADD, EDIT SAVE and DELETE function buttons on excel using
macros...so that my excel file will function as my database.....
thanks

Hi;
I would like to know how i can update data from one workbook to another
workbook.
please thank you

  Running Excel 2000 I dynamically create a command bar button but cannot
seem to make its .Parameter property work.
  Set myCBB = CommandBars("Standard").Add (etc...)
  with myCBB

I need help writing a macro that upon closing excel (current file name =
file1.xl) would prompt the user to "enter changes made", and then the
macro would add this text along with the name of the person who entered
the change, to a page in excel and save the file as file2.xl.

I have added a calendar control to one of my forms, and now every time
that I select a date and execute the macro behind the form, the system
date changes.  Has anyone else experienced this?  Is there a
work-around?