i picked this up last week on this forum and have not been able to get it to
run.  i can't get it to show up in the run macro dialog.  does anyone have
sugestions  as to how i can get this snippet to run?  thanks--
Private Sub User(ByVal Target As Range)

Hola,
I've done the:  
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in

How can I use the mouse or keyboard (or combination) to zoom in and out on a
worksheet in Excel?

I hjave installed the data analysis tool but this function (and the WORKDAY
function for that matter) do not work. By this I mean that when I type in the
function =NETWORKDAY or =WORKDAY and open the brackets it does not seem to
recognise it as a function.... any ideas?!

I would like to be able to manually reorder the field selections that I see
when selecting a drop down box in a pivot table but I am unable to figure out
how to do this.  Thanks.

Using formula =DATE(YEAR(K1),MONTH(K1+1),DAY(K1) starting with 01/01/2004 an
error is generated at 01/01/2005. However if I unclick Transition Formula
Evaluation and Transition Formula Entry in the  Tools/OPtions/Transition tab
autofill works but formulae in other cells don't ...

I think i must have missed something in my Excel learning...
What's the deal with the "~" symbol?
if you try to look something up & the text has one of those in it, it messes
up the vlookup.

In a formula I only wanted work days to be shown.  I used the WORKDAY
function which worked fine until I reliased weekends and holidays were missed
when the DAYS parameter was 0 (this value comes from a reference cell and
determined by other occurences.).  Out of despiration I ...

I have a long list under certain pivot table fields, and I would like to
reorder them so they are not in alphabetic order.  I have read in help that
you can drag and drop manually, but for some reason I cannot figure out how
to do it.  Any ideas what I am doing wrong?  Thanks.

I have been upgraded to Excel 2007 at work. I have been having problems
working with versions of workbooks that are linked to other workbooks. On the
previous version of Excel it asked you if you wanted to update links or not.
Everyone here at work knows to answer this question ...

Hope you can help me
In the spreadsheet the formula is ie =D283/D190. At this moment all the
figures are zero reason why it is returning #DIV/0!. Some of the cells in the
tables might stay like this for a while. Is there a formula that I could

Cannot enter the minus symbol "-" as the first character in the cell in Excel.

Many users access data for my application. The data is stored on seperate xl
files. These data files only open long enough for information to be retrieved
form or saved to, then the file is closed. If by chance the file to be opened
is already open by another user and in a Read ...

I just can't seem to remember how to do a format like I want.
I want highlight multiple cells in a row IF a cell = N
IE:
cell A1 is N I want to highlight cells A2-A10

   Ok, here's my problem: I have two worksheets. The 1st sheet has data
arranged like this:
Item1  SubItems  Date1   Date2
          subitem1