I want my workbook to not prompt the user to save it on exit. This is
because the form is showing information from files that the user
selects and when they close the workshhet I want it to remain in the
state it was in when the opened it first.

I am using a universal SQL editor and when I get the results from my DB query
using that tool, the columns are in the correct order in which I have placed
them.
However when I use the same SQL query in Excel and the data is displayed the

Private Sub CmbBxOpening_Change()
TxtBxWTOpening = Format(CmbBxOpening.Value / 3 * 5, "0.00")
Tscore1.Value = Val(TxtBxWTOpening.Value) + Val(TxbBxWTPolicy.Value)
End Sub

am using 2007.
Assuming I have a named range called "ColorRange", I need to have something
which goes through the range and for each row, evaluates whether or not
MOD(row()/2)=0, and if it does, colors it a shade of some sort.

I have a cell I2, which is validated to a dropdown list, and everytime
someone selects something from that list, I need a macro to run.  Is there
some simple code I can put into the sheet, book, or whatever (2007 Excel),
which accomplished this?  I know there were ...

I am trying to add a caption to  a control button on a command bar using many
variations of the following code in the Workbook_Open event:
Set myBar = Application.CommandBars.Add(myName, msoBarTop, , True)
With myBar

When i sent a vba programmed file to users, some of them don't work because
of missing references.
Is it possible to attach reference to file sent so that everyone can run the
program?

I have written code as below:
Private Sub Worksheet_Deactivate()
Dim sh, Target
On Error GoTo ErrorHandler

Hello All;
I have been trying to change this VBA to suit my needs. I acquired it from
here:
http://www.rondebruin.nl/mail/change.htm

I've seen various postings regarding this subject but have not been able to
apply them to my application.  
What I need to do is append the @Sum function to the last row of an Excel
sheet so it will sum the values in the columns.  The spread sheet is filled

Is it possible to preserve Excel undo stack after running a macro. It seems
that Excel clears the undo stack on running a macro and all the previous
operation are lost.
Any help appreciated.

I am trying to find if VBA has a utility that makes it possible to set the
Open File Dialog to a specific folder.
For example, if I use this code
Application.GetOpenFilename("Text Files (*.txt), *.txt")

I was wondering if VBA as a method that allows you to open a folder directly
use the Open File Dialog.
For example if I use this code:
Application.GetOpenFilename("Text Files (*.txt), *.txt")

Well guys, I'm trying to speed up calculations. To this extent I was
wondering if DSUM is faster than Sumproduct... brain tells me it should be
since sumproduct involves multiplication, and Dsum just logical sums.... But
a newbie to Excel, so not sure how the engine functions!!!!

i need help with a formula that will move the curcer to a certain.
example
if cell B2=05b1000,then go to cell A7
if cell B2=05b1001,then go to cell A15