I have a protected sheet with password say "1122"
In the protection window I have checked the box of "Sort"
I selected whole lines from 14 to 40 and tried the: Data|Sort and had the
error message:

How do I remove the data without removing the formulas?
Thanks.

I have two workbooks, A and B.  Both workbooks had the same macros.
I later created a Personal Workbook (Personal.xls) for all my
macros, so that I can use my macros in new workbooks.  I even
created a command called “Macros.”

what is the correct way to save excel worksheets, and word documents
when i open either one i get unreadable characters

I want to format a cell so that the user could enter in a time without
having to enter in the colons. Can this be done? Ie. 1400 = 14:00
Thank you
 David

I need help on my if statement.
I am populating selected cells in a spreadsheet by use of a userform.
The polulating works great. I would like to adjust my code so that if
no value is selected from from the combobox then the target cell will

I have a spreadsheet – with 60 rows of Tasks on the left side and 75 columns
of Cities on the top.    Each City has two different inputs for each
row/task, i.e., for the task in Row 3 -  Baltimore takes 15 minutes to
complete the task and performs the task 4 times.

i have to columns date and name (ex : Andy - 03/01/79)
i would like to count all Andy's cells of every monthe (january=3,february=2
...)
How can I do it ?

Is it possible to change the color of the little triangles at the top right
corner of individual cells that indicate someone has placed a comment on the
cell?  They're currently red, but that becomes a problem when the cell has to
be colored red (and, no, it's unfortunately not ...

I'm using, and love it, Excel 97. I want to know how to increment
TIME.
Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is

How do I calculate the z factor automatically by using Hall-Yarborogh equation without changing (Y) every time to reach F=0 ?
if any body know .please answer me.
Thank you very much
khalid

I have office xp and i want to open a existing excel file without excel
opening first a new workbook.
Rikske

How do I calculate the z factor automatically by using Hall-Yarborogh equation without changing (Y) every time to reach F=0 ?
if any body know .please answer me.
Thank you very much
khalid

The following keys have a blue color number on them: u, i, o, j, k, l, and m.
How do I convert they keys to use them as number keys.
Thanks

I have Excel 2007 and when I open a file from an older verion of Excel and
want to close it, it always prompts me to save it in the new 2007 format.
Is there a way to turn that prompt off?