can anybody help me with this?
I need a command to add at the beginning of a macro which can be executed
when my Excel file NAMES.XLS is opening. The macro should be part of NAMES.XLS
This command should open another file named Q1.XLS

I am pasting data into Excel from an external source by using special paste.
This is working with no problems apart from all the data is going into one
cell.
How can i split it up into different coloumns.

I've been reading some things on the web about macros.  I experimented
a bet.  I have a couple of questions.
How do you make the macro apply only to a specific sheet?  When I made
my macro, not only was it in every sheet in my workbook, but when I

why does this code not work? ? ? or what have i missed out??
Private Sub CommandButton3_Click()
If Me.TextBox1.Value = 74987 Then
   Worksheets("Bank View1").Activate

How do I draw information from a cell within Excel and show this on a
label/caption on a Userform?

I have this code which works great:
Sub Delete_blank_rows()
       Dim Lrow As Long
       Dim CalcMode As Long

The following code works for the first ActiveSheet.ScrollBar1.Value command
works, but the ActiveSheet.ScrollBar2-9 commands do not.  The last 4 commands
(ActiveSheet.Range("D10) through "D16" also work.  Appreciate any help.  
Thanks.

    I need a snippet of code to implement the code show here, but
using variables as the range argument.
Worksheets("graphs").Range("A1:B200").ClearContents
What I would like to do is replace "A1:B200" with an integer value (to

I want to be able to manipulate and get information about a large number of
commandbuttons using something like:
  x = Worksheets(2).OLEObjects.Count
  For b = 1 To x

i got a workbook thats used on 5 machines on diffrent locations.  the ppl
using it are not all that computer litterate...  
at the moment i tell them to "alt" "t" "t" "p" to unlock the page if they
need to manualy change anything in a locked cell. problem are they now erase

I have a problem with adding series to a newly created graph in VBA
The ranges for my data need to be pulled from a variable amount of
sheets, based upon the data I am currently working with.
The array to obtain the variable values is in an array of integers

I would like to create controls on different sheet.
But have the event code in the main workbook.  And have none in the
worksheets.
Is this possible?

I'm working on this excel file. The sheet is called RawData and it has data
from column A to K. There are 3 additional sheets called Mandatory, Voluntary
and Global.
How would you write a macro to automatically look at the first row in

I wish to paste a named range from Excel into a Word Document using VBA.
From Excel I have created a Word document as an object, but cannot
understand how to use any of the Word VBA code I have recorded.
In Excel I can easily reference the named range I require to insert, but how

i got a workbook thats used on 5 machines on diffrent locations.  the ppl
using it are not all that computer litterate...  
at the moment i tell them to "alt" "t" "t" "p" to unlock the page if they
need to manualy change anything in a locked cell. problem are they now erase