I have workbook that is protected except for some certain cells.
I want to spell check only the cells that can be altered not the other cells
i also want to hide the password so that no one can find it out by looking
in the macro

I am trying to split 700 names with phone numbers. They are in column A.
There are hyphens between the names and phone numbers. Do I have to replace
it with a coma and if so can i do the first one and copy it to do the rest or
do i have to do each one individually. I not really ...

Hi I am trying to get a workbook that I have crerated on Exel2007 PC onto my
PDA Exel , How do I do it
regards Tony

I have a sheet that I need to sort by 5 critera (columns) not the limit of
three as is in my Excel 2002.  Can that be done?
Barney

I typed =8^1/3 and I get 2.6666 instead of 2. Why? However if I type 2^3 I
get 8. Thanks

This is probably something super simple.
But for some reason, i cant figure it out.
I have a list of dates in ascending order. (C2:C1000)
6/20

Hello, I was wondering if someone could assist me.
I tried figuring this out with a Index and Match formula but cant get
it to work. Using the example below, I'm trying to put a formula in
Column E that will let me know if there is anything scheduled for an

I'd like to know if it'll be possible attach a file (word, pdf...) in one
cell. I'm doing an Excel doc. and I need to put some instructions by doc.
attached. in some cells. Thanks!

here is an example of what the massive data looks like
A (sheet 1)     B(sheet 1)          A(sheet 2)      B(sheet 2)
store              states                  store             states
1                      -                          4

I need to format columns to allow only 7 characters and the rest of the data
to go into column B  

Hey fellows
To fresh up my update-macro I want to show the user a DownLoad Bar
that increase (fill in with blue color in message box or similar)
while the macro runs.

I have a workbook with multiple sheets. One sheet is a overview from
all the sheets and had all dates in it.
Is there a VBA to hide columns when there are no entry's in it?
The code has to work when I open the sheet "overview"

My workgroup has a shared drive that everyone has access to. All files
and folders are available to everyone in the group. I've created a
project database using Excel 2003 SP2 that contains hyperlinks to
files that are contained in various folders on the shared drive. These

(In XL 2003)
I have a cell that is validated to only contain any of the numbers 1 through
5.
What I want is to have another cell that will only accepts a range of

I've got an Excel worksheet set up where there are two columns for each day
of the month.  There are ten rows.  A user should put an X (I'm using a
colored-fill) in just ONE box in each column every day.  The user should be
able to change where to put the X, but shouldn't be able ...