When my wb is opened with macros disabled only one sheet is visible. I
want to prevent the user from scrolling on this sheet, which i can do
when macros are enabled but not when discabled. Is there a way to do
this? (I tried setting the scroll area but this doesn't seem to take

I want to put this formula into a cell via VBA;
=IF(C4 = 5,"ACTIVATED","NOT ACTIVATED")
However this would mean the code would be;
range("c4").formula = "=IF(C4 = 5,"ACTIVATED","NOT ACTIVATED")"

I need a code which can alert me with a message box when the value of the
cell changes from "OK" to "CHECK". Can anyone help me.

I want to add a date at end of the file name.  How do I do that?
Also I want to over write a file if it exist at this location but I don't
want a box to pop up.  
Dim WBNew As Workbook

Someone tried to respond to this link will not open. I tried google stumped
HELP
copy a macro over to run from vba in Excel works fine in word. When try from
excel will not go to printer

Within my worksheet is a number of cells that MIGHT contain a name of
a Month
white mothistled January holdew February tracour December necters
exally slopers

I have this values in separate cells in sheet called "source"
04 2930 EA 3.00 3.00 1.00 1.00 0.00 16.75
Feb '08 0.0000 Nov '07 2.0000 Aug '07 6.0000
Feb '08 0.0000 Nov '07 2.0000 Aug '07 6.0000

I have a part list which I update monthly.  In most cases the part numbers
are 10+ characters long however after the first 3 or 4 characters I can
determine what kind of part it is. What I would like to do is create a macro
that based on the first 3 to 4 characters would populate ...

For last one year I posted at least 5 times to find out why that edit-fill
"series" is not highlighted in one particular work book and for code running
very slow.  
I thank and appreciate Mr. Mark Ivey,  who guided me with emails after

Userform put on the two textbox.they are names textbox1 and textbox2.
They are valeu's character length four if textbox2 selecting.
what is userform events?
-------------------------------------------------------

Below you will see the code I am having problems with. The macro 1st imports
a text file and then updates another workbook with it. I need to select it,
export it to excel and then update another workbook with it. The first
problem is with the code that imports it. Also when ...

I have the SpellNumber macro from the following link,
http://support.microsoft.com/kb/213360
It works fine.  But, i want some modifications or alterations in the macro.
I need to use the macro for Indian Rupees.  I have tried to edit the macro,

I've got some VBA code running in some VBScript classes that works in
Excel 2000 and 2003 (or excel versions 9 and 11) that identifies a
series object in the following way (assume taht oMyChart points to a
valid chart object):

Can somebody please to learn me if ADO
can do an autofill method in a closed workbook ? ...
... to do in a closed workbook the same action
like in VBA  :

We have an excel application that uses CopyPicture on an Excel
worksheet that has text and bar graphs, then instantiates a Powerpoint
object and pastes into a slide. In versions prior to 2007, this works
fine. But in Excel 2007, the paste displays correctly, but when