I have a Command Button on a worksheet that I only want to display if a
specified User Opens the workbook.
I have the following code:
(in a UserName module)

When pasting these numbers into Excel:
210000000000026324
210000000000026524
210000000000023324

Ok, I haven't been drinking...This has been verified on multiple
computers, with Office 2000 & 2003.
I have a worksheet that contains hyperlinks to other worksheets within
the same workbook.

I have a cell where if the cell is empty (A1=0), then I would like
the
cell to display "Enter your value here."  Otherwise, I would like the
cell to display the value a person enters.

I want to catergorize the coupons with a drop down selection bar so it will
be easy to catergorize them by type....also by date and manufactureer

I have a worksheet with three ranges with range names Amount,Name and Type.
I would like to write a SUMIF formula to give me the total based on two
criteria.  .  Amount is numeric and Type and  Name are text.   I have tried
something like this but keep getting an error.

I have pivot table with inventory data, such as category, part number, quanitty 1, quantity 2, etc. Just outside the pivot table i have a column called "Quantity Counted", which will be manually entered, Next column is "Variance"
What I want to add the two data fields from the ...

I have a macro that has been written to open to different text files
(using Excel), retreiving some data and bringing it back into my
workbook, (bits shown below).  At the end of my macro, I have a column
that I have to use the Text-to-Columns feature using a comma as the

To All,
A basic question regarding conditional Formatting.
I can not determine how to perform an IF function based on the color of a
cell. For example, I would like to add a column but exclude any

Is there a way to check grammar?  I can spell check but then end up cutting
and pasting into a word document for grammar check.  I read somewhere that I
could embed it into a word document, but I don't know what that means.  With
the cutting and pasting I have to either go back ...

is there a way to autoformat shading in all odd cell numbers?

C1:C7 Sheets("Page") contain details of the particular job.
I am trying to write a macro to add a Text box on another sheet "Schedule"
to include these details.
Recording a macro of the first few operations, initially typing the text, I

In Excel, I prefer to copy & paste other items, but like to use an ellipsis
frequently.  i.e., is there a "frequently used" function, so that I don't
have to be copy/paste over & over, &/or go into Insert/Symbol, each time I
want an Ellipsis.  Basically i want to click, or maybe ...

I'm looking for an answer, but I was wondering if this message was
ever solved?
I have one user with Windows XP and Office 97.  He'll be working away
on some Excel sheet which is usually big (not huge) and with macros.

Is there a way to extract information about the creator of a document and
when the doc was saved and edited beyond the info that is available in the
Summary under the document properties?
I have tried using low-level binary editor but cannot even get all the info