Hi, please can anyone help.
I've been using the fantastic code from Ron De Bruin at
http://www.rondebruin.nl/sendmail.htm, and have also got around the 5
second XP/Outlook 2003 security feature by using other code found at

I have a label on a form that I use to show the progress of a loop.  It works
great except if I change the focus to a different application and then return
to excel.  Doing so freezes the label where it was when I changed the focus.  
Is there a to get the form to start refreshing ...

Trying to do some basic animation with an autoshape.  I have a rectangle
that I am changing the size in steps.  The problem is, it resizes the
bottom edge of the rectangle up instead of moving the top edge of the
rectangle down.

I have a piece of code as below that works fine, but I can't find an
alternative that works, avoiding the two .Activate lines .
I've tried with...end with, but it gives an error.
Any suggestions?

Is there a way to use 3-D referencing and labels in the same formula?  For
example, I would like to add up the total number of vacation days employees
at my company have taken throughout the year.  My excel program has a
worksheet for each month (January to December) and a totals ...

I'm beginning my studies with Visual Basic on my Excel 2003 and I have a
problem with calculations concerning adding. I will write the source and I
hope somebody could help me. The problem is that the calculation below gives
me a result 34 if A=3 and B=4. However if I try to ...

This code is on the worksheet module. It hides the commandbar that is
unique to this sheet when the sheet is deactivated and erases the
commandbar name from the worksheet so that XL doesn't try to hide the
toolbar when the workbook is closed.

Hi Gurus !
I have (successfully) used in my code (7-8 month ago) :
Private Sub Workbook_Open()
   Dim Sh As Worksheet

Hi, I have some code to save a backup of the workbook. However, for some
reason it automatically saves to My documents every time, whereas I want
it to save into the same folder as the original workbook. The code I
currently have is below. Could anyone tell me what I need to change ...

I am using excel 2003 with a shared workbook. With a macro i enter info into
a userform to place data into a filtered list, the sheet is protected.
This works fine until the macro tries to change the auto filter to display
the new entry. The macro fails because the sheet is ...

Hi, I was wondering if anybody knows a way, through VBA, to create a new
folder in the same directory and then save the active workbook to that
new folder?
Thanks in advance

My VBA - Tool References - menu is freezed & can't check microsoft
outlook to send mail.
or if checked - macro to send mail does not run as menu is freezed
afterwards or option has been unchecked

Can you provide me with a coding example?  I would like to add a scroll bar
to a form with multiple fields tied to the scrollbar.  How would l code the
field references?  Thank you.

I have windows task scheduler setup to run some VBS code for me to send
out some reports automatically ever night for me. However some people
have started to figure out if they leave the file open the report will
not send. I have looked all over and cannot figure out how to do this.

Right i have a excel document with 54 worksheets.
I want to password protect the first two worksheets with an identical
password.
Is it possible and how.