I have added 6 buttons to my spreadsheet.  The last 5 are copies of the the
first one, so all of the properties are the same.  There are control toolbox
buttons.
One of the buttons kicks off a macro to subtotal the sheet.  I would like to

version is Excel 2000 SP3
-I have a ComboBox on Sheet two of the Workbook.
-The ComboBox has a ListFillRange of "S2:S9" where i have some text
-Depending on the ListIndex value of the ComboBox, the macro copies some

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A1:C1")
If Intersect(r, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False

Unfortunatly, I am not very well versed in VBA.
Here is what I need to be used within Excel 2007.
** 1 spreadheet has 30 worksheets.
1. I need a macro that will automatically go to the first worksheet,

Currently, I am working through some basic examples given on this
website: http://www.anthony-vba.kefra.com/index_011.htm. When I tried
the first example in Excel VBA Basic Tutorial 3, ie:
       Option Base 1

We have created a user defined function in VBA which has a number of variables
When we use this function in an Excel sheet we want the yellow prompt box
that you get when you use normal excel functions to appear.  This will then
help us to input the formula without having to use ...

Suppose that an Excel spreadsheet contains the value "Hello" in cell A10 but
is otherwise empty when the following code fragment is executed:
[code]Dim intCounter As Integer
intCounter = 1

I'm a novice VBA coder, but am trying to make this work. I have an
Excel workbook that contains 4 worksheets. The first worksheet is a
summary, and this is where I'd like to add a button to "Print All".
The remaining 3 worksheets each contain data as well as an embedded

I downloaded an xls template that I am currently using to generate my
invoices.  There is one cel where I type the customer ID.  And another
combination of cels where I type the customer name and address.  Is there
anyway to streamline this operation?

I have text file with about 300 lines items that are not delimited
but
the width of each columns is fixed and do have the value. For
example,

I have a spreadsheet looks like this:
QID    C1     C2    C3   C4   %a    %b     %c      %d
13123 b       b      b      b      0    100%   0%      0%
13124 d       d      d      d      0%   0%     0%    100%

I have a datapull from a propriatary db that we use and I have the ability
to clean up the data, no problem.
i have another workbook which is a report in a fixed format with multiple
sections seperated by rows. such that rows 30 - 81 are part of a section with

I have a command button on a worksheet with a CLICK event handler.  Is it
possible to toggle the caption on the button between say, Set , Reset with
each click?

I have code that I use to add or remove rows (at the location of the active
cell) on a work sheet.  I've been trying to modify it so it will work with a
set of Grouped worksheets.  It works fine when I am adding rows, but when I
need to remove rows, it only removes rows from the ...

We had a server crash.  We replaced it with a new box.  The old Autosave
location was:
\\<server name>\path.
Excel now can not find that location.  When I go to Tool -> Options, and