I am trying to force the user to always save the workbook as a newly named
file into a specific folder.  My problem is that the Save As dialog comes up
twice???? Here's my code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

I have a problem with selecting cells.
The selection allways goes from column A to M.
The number of rows starts allways from A 11, to the LAST CELL in column A
which contains a number

I have created a splash screen that works almost perfect.  I would like Excel
to preform the rest of the macros associated with a button while the splash
screen is showing.  right now the splash screen shows up, then when it closes,
excel will complete the rest of its tasks.  i ...

I have a Listbox I'd like to fill using a Range. My Range is named "Months"
and is located in cells "D1:O1"  
In Rowsource, I have "Months" (no quotes)
For some reason it only displays the first value and nothing beyond that.  

Having a problem working on a macro for excel 2000 hoping this group
could help me out I have a group of matching pairs 00 to 99 in
worksheet SHEET1 cells A1 to A455 not in order EXAMPLE
(00,44,22,00,55) and want to do a VLOOKUP or NUMBER MATCH or other way

I have a problem with selecting cells.
The selection allways goes from column A to M.
The number of rows starts allways from A 11, to the LAST CELL in column A
which contains a number

To all,
I need help with the following.
I have a list of part numbers in column A. In column D I have a list
of part numbers. In column E I have a price for these part numbers.

At the end of a macro I save the worksheet. The following statement works for
me, but how should the code be to make this work on another users computer
with another directory structure? (I copied this statement from another
answer - my knowledge of VBA is very limited!)

I need some code to do the following:
1) start with a given cell
2) count how many of the 10 cells to the right of it are filled with data
3) for each of those cells, perform a small procedure

I have a an application (workbook) running some VBA code, I want this code
to open another application (workbook) but prevent its open events being
fired to prevent the opened workbook VBA code running.  
How do I do this?

I have recorded a macro to try and position my cursor in the next blank cell
at the bottom of a list.
I have the following to send the cursor to the bottom of the list :
Selection.End(xlDown).Select

My question is this
Using the VBE I have rename sheetxx to shtInpinfo - Do I need the all of the
following code to use the range name "valid"?
If shtInpInfo.Range("valid").value <> 0 Then

Here is the code I have:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
   Application.EnableEvents = False
   MsgBox "You have clicked the X in the upper right corner!"

I have recorded a macro to run the auto-filter process, with the results
being shown on a separate sheet via the camera tool. The whole data range is
300 rows, but most results will be less than 20, though could be all, so for
neatness I am trying to hide the empty rows in the ...

Hi there. I want to create a graph for the title row and then each row
in turn of a spreadsheet, choosing the next rwo down each time.
Trouble is there are 150 rows and I want to write a macro to do it for
me. I have tried with a modicum of success. I can create a graph for