Is there a way to detect sheet name changes or prevent user from
changing the name of a sheet? Thanks.

I have a spreadsheet which can be autofiltered at columns A, B, C and/or D.
I have created a macro which autoruns whenever column D is changed. It
removes the autofilters, sorts the data by value in column D and then column
O and then reapplies the autofilter arrows. Is there any ...

Is there a vba code to check if the VBAproject is protected or not ,
and if not some action will be done ?

Looking to clean up a list of items by deleting certain unneeded data.  The
lines I want to get rid of contain certain keywords.  How (with VBA) can I
delete those rows?
Example: (have now)

I have this scripit in my form to add a new membership no. to the data
base entries.  This works fine if I run it from the same sheet where
the data is.  If I try to run this code from sheet 2 it gives me an
error.

Open any file, can't save, save as, cut, paste, delete a worksheet, protect,
macro.  Those are just a few functions that I can't use. They are grayed out.
How do I fix this problem?

I am using Office 2003 on Windows XP.
I have the following formula, which works:
=IF(SEARCH("*Option*",G2, 1)=1,N2*E2*F2,"")
However, when the search text (Option) is not found, this function evaluates

I have a set of data without headers. I want to programmatically insert a
blank row into Row 1, then add a header (e.g., the column letter) for each
column in the data range.

Has anyone figured out how to make and solve the "Suduko" puzzels yet. This
seems like such an easy excel program, but it's beyond me.
Just thought I ask

Hey all,
I have a series of IF statements below that checks MatchFound and if
false, removes the erroneous data from the field.
A couple of questions for improving this.

Is there a way to programatically tell part of a cell to be bold.  For
example, I have a cell that says:
Your library book is OVERDUE.  If you do not bring it back by MM/DD/YY, you
will be charged $$.$$.

I'm setting up an sales audit spreadsheet, and can't determine how to make
the 2nd set of numbers in a reference range variable based on a value in an
absolute cell, e.g., S1:(S1+$A$7).  This formula doesn't work, but what I
need to accomplish is summing S1:S15 when 15 is the ...

I've written a template that goes through a number of calculations
based on information entered into a worksheet. My code loops through
all the entries in this entry sheet, and as the number of entries
grows, it takes longer to finish the calculation. To improve my

Can anyone help me figure out what I have wrong here.  I think the code
shows what I am trying to do.  The problem with simply using a Left()
or Right() function is the data size changes, of course and I am
splitting the data.  I know this will work, but I can't get it to.  I

I have a macro which does the following:
1.- Save the excel template file (template.xls) as
WO = Worksheets("summary BLR").Range("M10")
myDateTime = Format(Worksheets("summary BLR").Range("M9").Value, "yyyymmdd")