How do you lock individual Cells so that user input cannot change it, BUT
it can change itself depending on Calculations from another cell on another
Sheet?
thx

I am trying to set up a macro that will find a row based on a specific word,
then underline that row in the table.
I've tried recording it, and the find bit is fine, but I don't know how to
change the vb code to allow it to highlight columns 1 through 7 on the row

Excel 2003, I create a chart programmatically. Now I would like to capture
Click Events on that chart I just created. It doesn't seem I can put code
under that object via code.
My actual situation is I have run time data, and my customer and I have not

Hi all,I got really confused.
First,I wrote this:
-----------------------
Dim ctl as Control

I have subtotal sum and average on the same data range.
The average and sum show on the different row.
Is it possible to have them on the same row on the spreadsheet?
Your information is great appreciated,

I am performing some validation on the Exit method of a
combo box. However, when user selects the Cancel button,
I don't wish to perform the validation.
In VB there is a button property called Causes Validation which

I have a macro, With the help of this macro, as soon as u write
anything in Column A it would automatically  throws a Current Date in
Column G:
Dim LastRow, LastCol, CurRow, CurCol As Integer

I was hoping if anyone could help me - i'm trying to write a code that
would create a dropdown in a cell on the fly. That's the simple code:
   With Selection.Validation
       .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,

I have attached my macro to a button and placed it in sheet 2 (which is an
empty sheet) but the macro doesnt work from that sheet. It does however work
if i put the button in the sheet where all the data is. I also wanted to
email a macro as well, how do i do this?

I am trying to retrieve data from a query in an Access 97 database and
populate Sheets in an Excel 2002 workbook using 'CopyFromRecorset'.
The problem i am having is that 2 out of the 7 Sheets (all sheets are being
populated one after the other within the same piece of code) are ...

Please does someone have the code or wizard to:
select worksheet(s)
selects columns to be appended from these sheets or sheet
append it in in a new worksheet

I'm selecting two separate areas of my worksheet using Ctrl-Click(drag);
a1:a4 and c1:c4
I would like to know how to get the column number 1 for colum "A" and 3 for
colum "C".

On selecting a commandbutton I need to automatically insert the time and
date into a cell. I know that NOW() would do that but how do i get the time
and date in VBA?
thx

I've got the standard task of referencing cells in other sheets from a
summary sheet using vlookup, no problems there.
The problem I have is that the sheet names to be indexed are listed in
a column in my summary sheet.  I can't find a way to create the

Hi, I'm very new to VBA and I'm trying to create an add-in.  The problem is,
after I've created it, I can't seem to load it correctly so that the macros
will be available to other workbooks.  I have read several pages of step by
step instructions online that are very good and ...