Functions

Change Workbook Password
Does anyone know how to change the password using VBA for the entire workbook from "x" to nothing - so that the user is not prompted to enter a password next time the workbook is opened? Thanks... ... 3 Jul 2008 13:33

How Do I DO IF with DATE
I have a workbook with 2 sheets. The first sheet has a report for individuals sales. Each row has a date then cust name then amount from left to right. The other sheet has a table setup to do monthly totals to figure commissions. First is the rep name then total sales for a given month then commission percent ... 3 Jul 2008 14:34

split data into seperate worksheets by criteria
Can you have a bulk of data in one sheet then split it into worksheets based on a change in data in certain columns? ... 3 Jul 2008 16:38

Ungroup "+" on a protected sheet
Does anyone know how to protect a worksheet and still have access to the "Group/Ungroup" functionality on the left ? Thanks! ... 3 Jul 2008 13:33

Counting specific letters in a cell
How do I count the number of specific letters in a given cell? For example if a cell has the words "Have a nice day!" I would only want to count only the letter "a." Is there some sort of IF-LEN-combo function? Help. ... 3 Jul 2008 12:31

Figuring and adding time in Excel
I have the start time in one column and the end time in another. Excel will subtract the time in hours and minutes. This is great, but I want to show 2 hours and 30 minutes as 2.50, not 2.30. How can I make it show quarter hours, half hours, and three quarters of an hour so I can add the column to show total... 3 Jul 2008 12:31

Calculate a ratio of two numbers to the total
-- Richard ... 3 Jul 2008 13:33

Automatically expanding outline section if values are present
We are currently using the Outline function. Our problem is individuals will expand the outline, enter information, and then collapse it. We then convert the worksheet to a tiff (durable format). The problem is if the outline is collapsed it does not print. What we would like to happen if values exist in c... 3 Jul 2008 15:36

If a date range contains a leap year (date)
I need to identify whether a date range contains a leap year day - 2/29. I have a start date and end date and leap year True/False indicator Start Date 01/01/08 01/01/08 03/31/08 06/30/07 End Date 12/31/08 06/30/08 12/31/08 03/01/08 Leap Year? TRUE TRUE FALSE TRUE I c... 5 Jul 2008 07:25

Nested if/then or array???
I've been using the vlookup function to reference a cell value (Sofa, Loveseat, Chair, etc), find it in an existing list/chart and return the standard value in a given column. Ex: =vlookup(r3, Lookups!A4:Z27,19,False) Works great. I've run into trouble however when in certain places I FIRST need to know w... 3 Jul 2008 13:33