How do I make (for example) cell A1 protected while B1 is editibale on
the same sheet (say Sheet1)?

Hi,
I'm new to Excel.  I want to create an inventory database in Excel on one
worksheet.  Once the database is populated with part #, price, etc., I want
to be able to select items from the database on another worksheet by part

I received a excel file, where there is "+" sign on the left. If I click it,
it expands and click it again collapses. What is that for?
Also I see "1", "2" on the top left. If i click "1" all the "+" expand and
if I click "2" all of them collapse.

I have two lists of email addresses
Column one are prospects
Column two are customers
I'd like to remove all the customer email addresses in col 2 from

RE Office XP - both Word 2002 and Excel 2002
when I click on File on the top menu bar  -  the only options I get now on
the drop down menu are Save, Save As, and the last 4 files opened.  All else
has disappeared.

I was wondering if it is possible to get a userform to maximize itself
automatically (to fill the entire screen) when it is activated.
Currently I set my userforms properties width to be 417.75 and height
to be 600 - which is fine for some screens but not for others. It would

I have named several ranges on my sheet with names of cities such a
"newYork", "Chicago", "sanDiego" etc.
I would like to use these ranges in a formula, but rather than type i
these ranges I would like to use a cell reference that contains thes

I would like to know the steps / method to be followed for converting
numeric values in figures.  
eg  If the amount, i have added has come to Rs.10,500/-
I want the value to be shown in words ( Rupees ten thousand five

-     2  2299 Del Pietro           M Wintervill NC 1:18:26 2:44:0
 2:44:11  6:16
-     1  2045 Robert Marchinko     M Salisbury  NC 1:15:34 2:31:1
 2:31:20  5:47

I have a sheet that requires me to clear all the cells to continue. My cell
are A2 to C30. Is there a button or something I can have to clear them all at
once?

Hello I would like to enable a button or macro that i can easily set up
so that everytime i change a value from a cell the printer message pops
up saying "If i want to print"......can this be done using a macro
without programming?

Any help is appreciated.
Have many pages to workbook. TIME and SPOT are frequent elements in each
page - want to create 2 drop down lists - if entering time - can be selected
from drop down - if the cell is spot - select from SPOT list - how can I

    Is there any way to copy a line of information, for instance from Cool
Edit (song title), using copy/paste and then paste that
into an Excel spreadsheet?
We tried using Copy but then Paste is greyed out in Excel.

I need to have a control collection that is public to other modules and
procedures.
When I declare it in the procedure it like
Private Sub UserForm_Initialize()