I have a Workbook with a macro that displays a custom command bar.  When
I use the Workbook on a machine that doesn't have my custom Excel.xlb
file on it of course the macro fails.
Is there anyway I can change the macro so that it will sense if the

I have a workbook which a colleague uses to enter data. The data is then
manipulated on the same worksheet, but if these columns arehidden they can
easily be unhid. Is there a way of password protecting these consecutive
hidden columns, or an alternative please

So, with a shared workbook (tools, share workbook), I have several people
working in the same worksheet.  Now conflict resolution seems to work by
saying, oh, userA changed cell A18 and so did userB - whose change should I
accept?

Hi, I am new to using the VLOOKUP function and would like a bit of help.
I have created a sheet labelled 'Lookup List'  and have data in the range
B4:H52 and sorted by column B
as follows.

The condition in COUNTIF can either be a constant,
or a logical expression, e.g.,
countif(range;"ok")
countif(range;">0")

Hi, this should be easy, but I have a mind block and cannot think how to
do this:
I have a column with numbers in, ie 1, 4, 12 etc, and another column
with a price each in. At the bottom of the price column I have the total

I have been entering data from surveys into an Excel spread sheet.
Each respondent may have up to twelve types of problems that they will
have written something about. I have created a separate column for
each row.This is what it looks like (if you get my drift).

Ok, I am not sure if this is possible in excel, but a friend asked me if I
could help him with
a problem, so here it goes:
Ok, Imagine a Excel spreadsheet file (A) with about a dozen columns filled

I have a chart that shows sales data for each company that has done
work for us by month for the past year.  Problem is that if there were
no sales for that company for a given month, that month dosn't show in
the graph.  What I need to show is a graph by company for every month

I have a workbook that I am convert into a pivot table.  The problem is that
the data is formatted as follows:
     Audio Geer Store #117 San Bernardino
    9125 East Hospitality Lane

Given a set of raw data shaped like this:
Cat    Item    Value
--------------------
 1        1        45

I am trying to write VBA code that accomplishes the following:
1) Copy Sheet1 from workbook1 into a new workbook.
2) Open the "Save as" dialog box that allows the user to name and save
the new workbook.

I need to do an if and statement something like this-
if A1=1 and A2x(A1)1>10 then no more than 10, but
if A2=2 and A2xA1>25 then no more than 25
so if A2= 12 and A1=1 then the result will be 10

Is it possible to delete the contents of all cells in a named range based
on the partial contents of those cells?
I import data from a database that ends up having thousands of cells
whose contents start with 3 asterisks and end with 3 asterisks and I'm

I recorded macro that imports a text file and adds headers
to the columns. When I run the macro it opens a new workbook
and inserts the text file.
Is is possible to add code that will copy the sheet from the