I am running a macro but it is not running smoothly due to many msg prompt
boxes appearing to ask to click "Yes","No" etc and there is also another msg
box that prompted me that there is a large amt of data from clipboard to be
copied over, and also another msg box that ask me to ...

I really need to be able to refer to sheets with variable sheet names.
I managed to get this working within one workbook using the indirect
function. However i need to be able to do this referring from one
workbook to the sheets in another workbook. The indirect function only

I have found a nice macro wich copies contents (related to a value)
into different sheets wich saves alot of time. Works fine exept i have
Hyperlinks in column B and the names are copied but the hyperlinks are
gone. Don't know how to correct it so that it runs the macro and

What my macro should do is move to the next cell to the right when the
current cell is occuiped.
sample of my data
    A1       A2

How do i call to close a specific workbook instead of the current active
workbk, because most of the books they taught is to close current active
workbk.
i tried workbk.close(filename), but it does not work.

I use the code below to show some textboxes and images while I play a sound
( explaining these images)... the problem that I can't solve is that
sometimes the code works and sometimes not. The sounds are correct all the
time but sometimes after the first textbox the other objects ...

When I programatically add a new worksheet in VBA, is there a way to
programatically set the CodeName property ...
So instead of showing as Sheet1 in the VB Editor 'Project Explorer', the new
sheet shows as what I want it to be.

On Worksheet_Change event I restore format of target cells and want to
reduce the execute time as much as possible. I have several other
restore subs than this, to restore validation, conditionformats,
interior.colors, fonts etc. and I hope I could make a difference with

Im a new user and am having trouble with code to go to the next row to
enter data into a spreadsheet.
This is the code I've tried (I already have items in rows 1-4 and I
just want to add onto the next one)

i have some 20 charts in a sheet along with the data. I want to change
the fonts of all the charts i.e. title, axis etc. i was able to do
this but some of my charts also have secondary axis and font for the
secondary is not changing.

I'm using Excel 2000
It seems to be incapable of creating a relative range name during a macro.
Even clicking the "relative" option still results in recording an absolute
reference  to the cell referenced during macro creation, rather than the

Historically you could disable Save, Save As, Exit, etc by using the
following:
Application.CommandBars("Worksheet menu
bar").Controls("File").Controls("Exit").Enabled = False

I'm sending an argument into a function -
Function Find_Them(Find_Item As Variant, Search_Range As Range,
Optional LookIn As Variant, Optional LookAt As Variant, Optional
MatchCase As Boolean) As Range

I am looking to copy from clipboard in a vba string and I am having
trouble doing this: I have used several code sample such as :
http://www.cpearson.com/excel/clipboar.htm and
http://www.vba-programmer.com/Snippets/Code_VB/Clipboard_Data_Using_API.html

A couple of simple questions. I'd appreciate some help.
1)How do I get a UserForm to open automatically when I open a
worksheet in Excel.
2)MORE IMPORTANTLY....