I have deleted all macros from an Excel workbook, but when I open the
workbook I still get the security message about enabling/disabling the macros.

The VBA Help library on my PC does not work properly (at the top where
it normally says "See Also", "Applies To", and "Examples", appear as
boxes with a dot in the middle).
I've tried re-installing, applying patches, etc. but with no success.

I have a single cell with text that contains multiple lines (ie text
separated by a chr(10) I think).
I want to get the text from the cell starting with the first character
up untill but not including the first chr(10).

I have a monitoring sheet which consists of a sequence of numbers, at the
moment I have used a =MAX() formula to display the maximum # on the status
bar, this works simple as I have defined the range. Now I want it to be more
dynamic; where I shouldn't be giving the range in fact ...

My application is stored on a server that can be accessed by a number of users.
When the workbook is already in open by a user and another person opens it,
they get the warning to either not open, be notified or open as read only.
How can I detect this and force the workbook to ...

I have this strange problem with a single text defined cell value changes
when XL03 worksheet form is opened each day. Each day, the users have to
re-enter the value in order for the formulas to work correctly and then they
transfer the answers to another monthly "summary" ...

Could someone help me in modifying the following code running on Excel XP.
1.    substitute RC9 with an array "P1","P1D","X1","P1S","U1","A1","X1D" (none
are cell references)  
2.    Instead of .FormulaR1C1, change to EvaluateR1C1 (to make the lower half

I'd like to create a macro that will do an autofilter of my worksheet
filtering out all cells that have defined names that start with
"PatRev".  Does anyone know if this is possible and if so could you
please send some sample macro code?  I've searched for an answer to

I need to be able to know how to have a cell when selected it would have
a drop down choice of 4 items :  "item 1" , "item 2" , "item 3" , Next
Object Number  
where if "item 1" is select cell would have text string "item 1"

I'm trying to pull data from access to excel using MS Query.  I have
three Access databases (for three different countries) that will
reside in three seperate subdirectories on the harddrive.  I want to
create one excel file that will work for all three applications.

Dim count ' counter
Dim people() As String 'array
  'find how many people listed in sheet 2 column A
   Sheets("Sheet2").Select

I created an add-in that was working right until I installed Essbase.
I added a line to Hide/Unhide sheets to the tab contextual menu, since I
have Essbase the macro stopped working and returns a Argument not optional
error.

I am creating Excel 2007 workbooks from Access VBA using an Excel
template (.xlsm) containing macros.  When I create the workbooks w/o
applying password-protection to the Excel files, the macros run as
they are supposed to.  However, when I save the .xlsm workbook with a

I was looking at somebody's Excel worksheet and they had included a little
cell format that I've never seen before and can't figure out how to
replicate.  They had formatted a cell so that the bottom-left corner of the
cell was red.  This little feature looked a lot like Excel's ...

I have a spread sheet that has several check boxes.  When a certain check box
is checked I need to hide other check boxes along with hiding the row.  I
know how to hide the row when a check box is ticked but I need help hiding
the check boxes. Is this possible?  Any help would be ...