I am sending an email using VBA code.  There are no issues with the code,
except if I use .Send then I get a prompt box to answer "yes, i'm aware of
this" action.  Is there any way to avoid this prompt?  I have many emails to
send via a loop and don't want to have to click yes ...

can I format a cell so when the data is entered it does a carrage return and
moves down one row and back to the left to the first column?

This is my first time using Excel 2007, before I used 2003. How do I
insert buttons into a spread sheet for excel 2007?  Do I need to
install any special package? How do I enable a button on the ribbon so
that I can drag and drop the button onto the spread sheet?

I have a userform called GetJob in which the user inputs a reference number
into TextBox1
I want this number to be searched for through column A of the DATA worksheet
and then copy the whole row of data when found and paste into row 2 of the

I calculate my variable counter by counting the number of rows in the
previous worksheet. The value ends up being 107, which is correct.
The problem I have is that I have to later functions I want to use that have
a varying number of rows and I want use the counter variable as ...

   Still having an issue-formula reads:
=IF(AND('Pietra Majella DI'!$I$34<>"",'Pietra Majella Ware'!$I
$34<>""),"ERROR",DI&WARE)
But ERROR is the message I'm getting even though there is only 1 cell

I missed something here, because all Worksheets get printed, ignoring
my Select Case. Help appreciated
Sub SummaryPrint()
Dim A As String

How can I determine what the "ActiveControl" is when the control is on a
multipage (tab) control?
Is there a way to iterate through the control on the multipage tab and
determine which one has the focus?

This is a copy from a previous post, thanks to Tim H.  I am resubmitting it
because I can't believe nobody else has experienced it:
When creating a vba list box in excel, word, or powerpoint version 2000 or
2003 (with or without sp3) or Excel 2007, the application ...

I have placed several check boxes on a spread sheet using the Forms toolbar.
The spread sheet is read only and protected. The check boxes can still be
selected and moved or deleted. How can this be prevented? Below is the macro
that I am using:

First of all thanks to everyone who has helped me so far.
I have one little quirk in my code and I'm not sure how to fix it.  The
following code works fine if there is more than one instance of "Account
Category:*" found in col. K:T, but if there is only one instance found, I get

I want to display the current setting of Tools / Options / Calculation
("Manual" or "Automatic" or "Automatic except tables") in a cell of my
workbook.
Question 1:

I am trying to creat a excel(2003) sheet that when you click on a button
(yes/no) certin cells will dissapear. hide. and when you click on the other
button they reapear.
I will have several sections that this will apply.

I am using excel vba to access our intranet site.
I am entering login id and password thru vba.
Now I need to click a button on the same page but no matter what I do,
I failed and need your help.

I linked one big file by using Vlookup function but when I trying to open
this file it is taking long time to open, so I need VBA macro to opening this
file fast.
Please any one can help.