I want to create one file of sensitive data that I can send to multiple
people.  Each recipient would enter their employee number and password to
access the data.  If someone has done something like this in Excel, please
let me know how it was accomplished.

Hi, I am pulling my hair out on this one. I just switched to Excel 2007 and I
cannot figure out how to Ungroup rows without also Unhiding any hidden rows
within that group. I really need to be able to Group/Ungroup without Unhiding
rows that are unused.  This was never a problem ...

I'm using the following code to size and display a specific picture based on
my list box in cell A4. It does a "VLOOKUP" from cell A5 and then displays
the picture that is tied to the selection in the list box. This code is
specific to cell A5 only. I need to duplicate this ...

JE McGimpsey mentioned this keyboard shortcut in a post back in June 2008.
It appears to change all cells in a spreadsheet from dates to date serial
numbers and vice versa.  But I can't find any mention of the shortcut in
Excel 2003 Help.  Can someone tell me where it is in Help ...

Worksheet named "Data" has two columns, column A is types of fruit.  Column B
is quantity of that fruit.
Apples    1
Apples    5

Hi - Is there any way to prevent a user from copying the contents of a
worksheet? I don't want users copying anything into different worksheets that
I have no control over.

Back in June, I asked (under the heading "CELL FORMATTING WILL NOT WOK") how
to resolve a problem I was having applying date formats in Excel 2000.  A
lot of people offered help, and I spent many hours applying the various
solutions offered, all to no avail.

When typing in a lower case "i" it shows up as an upper case in my spreadsheet.

When one tenders on a contract, there is a clause about escalation of the
contract price. If I remember correctly, one formula is for labour and one
for material. Can somone please help??? Ronnie.

I have created a spreadsheet used to track gas mileage.  Each row
contains the date of fill-up, amount to fill up, pricer per gallon,
miles and then calculates mileage.
There is a separate section that calculates the average mileage per

My spreadsheet is as follows:
1/3/2005    7:15 AM    8:15 AM    1.00    0:30
    8:45 AM    9:45 AM    1.00    0:15
    10:00 AM    11:00 AM    1.00    0:00

Is it possible to remove conditional formatting setting vai a macro.
I use a macro to copy a range (visible rows only) to a new sheet, the
cond.formatting gets messed up because the row numbers change.
The macro recorder doesn't record the cond.format part.

I have 2 worksheets. I want to obtain the summary counts in worksheet 1 from
Worksheet 2. What formula should I use to poulate worksheet 1.
Worksheet 1
2008 File counts by Lender and Month

Can I setup a worksheet to copy data from another worksheet in the workbook
based on the entry in one column?   On WS #1, can I have a function that
looks to WS #2, column E and if E="T", then copy that row, column a,b,c&d?  
AND have that function repeat itself until the end of ...

When I click on an Excel 2003 file a box pops up UNABLE TO READ FILE.  I
click OK and the file opens.  Anyone have an idea