How to disable unhide sheet menu option. i dont want people to unhide hidden
sheets in my excel workbook

I have an RFP I am working on.  I am scoring 3 different companies on a
variety of areas.  Each area is weighted a certain percentage value.  For
each area, I will give a score of 1-5 (5 being the greatest).  I need a
formula to calculate the percentage for each area based on the ...

I am a newbie here and at a very basic level of visual basic.  What I
am trying to accomplish is to remove the formatting of a phone number
and I am trying to remove the first bracket around the area code of a
phone number. What I want to do is create a macro that would repeat

Gurus,
I need a little help with a sumproduct function.
In my worksheet I have two fields that have data validation lists in them
that users will select a value from.  This works just fine.  The sumproduct

I need to generate a formula dynamically with VBA code.
The following code generates the desired formula in the debug window. If I
copy this into the cell the result is as expected.
But I need the formula being generated dynamically by the Worksheet_Change()

I want a cell to be highlighted red if it contains the letter D AT
ALL.  Not just highlighted if the cell ONLY has a D.
For Example:  a cell that = "D 8/17" or "D 9/10" should be highlighted
red.  The dates after the D will constantly be different, I just want

I have formulas that I want to round up to the nearest $5.00  My formula is  
      =+(M4*1.1)+M4.  I have tried =mround, but I am doing something wrong.  
Do I need to freeze part of the formula?  Please help!
Tx

Hi there, Does anyone know how to turn off the auto backup copy that is saved
everytime you save a new worksheet.  I tried turning off auto recovery but
that doesn't seem to have helped.  Any suggestions appreciated

I have a spreadsheet with a list of invoice dates and the amounts due.  At
the bottom, I have due dates a week apart
08/03/07
08/10/07

Good morning –
No amount of post searching turned up my answer, believe it or not.
I have a two-tab workbook.  Tab one serves as a Table of Contents for
different locations on Tab 2.

Hi, I need to make a letter have a value, so I can then use auto sum to then
add up. I need the letter H to have the same valve as one, so I can use this
on an attendance sheet, so when some enters H, it will then be counted as
one. I can then see how many days someone has had ...

I have a 2 worksheets:
Sheet 1:
Account No.    Profit Center    Group
31000                   80000000   

    Result
1    Red
2    White
3    Red

I followed the instructions below and they work.  But now, I have to wait 5
seconds after each new workbook entry before the cursor even moves.  For some
reason, this is a memory hog.  Is there something I can do about this?  The
functionality is great, but it takes too long.

I have a workbook I inherited.  I set up a range to protect so that the cells
are editable when the sheet is protected.  But even when protected there are
other cells that are not protected.  I did not specify them and do not see
them in the list of ranges that are excluded from ...