Can anyone tell me how to make the picture can zoom in/zoom out,
contract/expand picture using excel vba user form? is it possible to
make it?

In XL 2007, I add a program that adds a custom menu item to the shortcut menu
and it works fine.
BUT, two things:
1) A menu item in the ribbon called "Add-Ins" appears. How can I delete or

I have two macro's and one of it can split the data in different
sheets according to their values in column and second macro works to
send those splited file to specified e mail address according to
their

Can any one guide me with a code which will NOT alllow DOUBLE SPACING
in the work sheet ?
hoysala

of ObjectHallo
Is there anybody can help me since I am new in VB and having case as follow:
I am working with two workbook where when I open the 1st workbook it will
open the second one. The problem is if the second file already open I got an

I initially wrote the macro below with manual wait times to slow it
down so the shell outs would work. I ran across some code on Microsoft
knowledge base that checks for a files existence before continuing
because the wait times worked on some machines and not others because

First, I'm not completly sure this is the correct group for posting this,
but I figure if anyone would know an answer, they'd probably be looking in
this group.
Anyway, I'm trying to import Excel data into a .NET dataset using c#.

how can i write a simple formula to find the row numbers for all the
cells in column A that contain the text "YES"?
i've been trying the row, cell, and address functions but haven't
managed to get too far.

How can I check to see if the autofilter is on before I launch my code?
TIA
Mark Ivey

I want to create a chart with 1 serie which has data from 4 discontiguous
cells.
I defined 'b=6' but in practice it has a variable value, also counter has
variable values.

How can I write a formula to increase a different cell by 1 if an IF
ststement is true?

I'm making my first forays into Access with code.  As part of a data
export sub, I create an instance of Excel and add a new workbook.  I
create the name of the workbook with the date in it.  As I'm testing
this, Excel keeps giving me a warning that a workbook already exists.

For example in Excel 97 when recording creation af a rectangle, following VB
code was shown:
ActiveSheet.Shapes.AddShape(msoShapeRectangle, 25.5, 26.25, 155.25,
36.75).Select

I am wondering if someone may have an easy solution to help me create a
summary worksheet according to a special field identifier...
Here is the nuts and bolts:
I have a main worksheet with parts information:

I am making a macro toolbar for efficiency sake. Problem is, in the
commands of customize toolbars, I cannot find the 'stop recording'
command to add to my toolbar.
Is there someplace else I should look for this command, or some other