Hello, Excel 2003 and 2007. I have numerous macros in my spreadsheet and
have been forced to change the name of the worksheet and workbook over the
past few weeks. Today I sent the worksheet out to others in my group and
some of the macros refer directly to the pages within the ...

I have a macro that I want to write code for various commandbuttons that are
created via macro.  I manually put a check in the "Trust access to Visual
Basic Project" spot under Tools>Macro>Security.  But it keeps unchecking
itself.  

I have a sheet tab that contains data + one Picture object.  I have a macro
that allows users to copy/paste this data onto a master sheet tab that may be
blank (if it is the first copy), or it may contain previously copied data.  
Over time, the user will likely use this ...

Does anyone know how to change the color of characters in a cell based
of a cell reference.
For example, cell A1 = "||||||||||" (contains 10 "|") I want the first
4 "|" to be Red and the second 6 to Blue. Based of cells A2 = 4 and A3

I've been providing interim solutions for financial issues our full-
fledged developers do not have time to address.  Some of the interim
solutions have a way of becoming defacto permanent solutions.
I'm always trying to find ways to build a better mousetrap but my code-

I have three individual sPattern's that I am working on.  How can I
merge them together so that the pattern will look for three digits
followed by either a period, or by a space and a period, or by a space
and a letter?

Excel 97: In one of the workbook, in the -edit-fill- the 'series' option is
not highlighted but in rest of the workbooks the 'series' option is
highlighted.
Unfortunately, that sheet has lots of places where I have to use serial

  I have 2 ranges A1:A5 and B1:B5 and in column C I am trying to do a
sumproduct and I am entering the formula in C1 sumproduct(A1:A5,B1:B5) it
works fine in the cell C1 but when I copy the formula down to the cells C2
throgh C5. The formula becomes   sumproduct(A1:A6,B1:B6) and ...

I'm just beginning to learn about Macros and VBA.  I tried to create a macro
(where the macro was created based on my keystrokes) where one of the steps
was to solve a linear program using Solver.  I got an error.  I didn't know
if I did it incorrectly or if this is beyond the ...

I have an Excel 2003 template that I need some help with.  When the user
opens the template generating an xls file based on the template, I have code
that disables all builtin commandbars and creates a custom one with just a
couple of buttons.  On the BeforeClose event I ...

(See Sheet Below)I need code that would find the name in C column and get the
Test Result associated with that name in the D column. Do this each time it
sees that name, average the results, and place that result in another
specific cell.

I meant to post this question here, but accidentally ended up posting it in
the Excel General Questions forum. Rather than re-post the entire message
here, I'll summarize the question here. If you are interested, please go to
Excel General Questions and view the entire post there ...

I've got the following code that does hide the rows indicated, but it
also hides rows where the check box is...as you see I've tried to
force the rows it's hiding my mistake to unhide, but that doesn't even
work - HELP?

The Client currently is using Excel for data storage.
They want to continue using Excel front end for data entry, but store the
data in an Access database.
I have googled lots of information about using VBA DAO/ADO to implement such

how can i search for a string in a selected column without using lookup
function:
Here is what I need:
if (a1=sheet1!a1:a100) and (b1=sheet1!b1:b100) then put in the current cell