After adding a 'progress meter' to the report I am currently working on, I
discovered that the naming of the ranges which I perform first on each sheet
was taking up the vast majority of the time.  I was investigating by adding a
timer to the naming procedure, and I discovered ...

When a worksheet is named and copied from one workbook to another workbook
via a macro, is it possible to check whether that worksheet name already
exists and if so to paste over it and not make a new sheet, as in Worksheet
Name (1)?

Using Office 2003 and Windows XP;
I would like to insert a suggested file name automatically so when the user
invokes "Save" or "Save As" this name already appears in the file name box
--- how can I do this?

inherited a workbook that runs a query when the date in cell B2 is changed. the
query was set up manually, no code.
i tried a QueryTable_AfterRefresh on the sheet the query exists, but it didn't
fire.

Hi all, I need to track whose made changes in my workbooks.
I found the post from Gary but I can't obtain a result.
I have macros in my files. Anyone can help me?

Hi guys, is possible to create a commandButton to browse files, like windows
bowser to load txt files on the excel worksheet?
the second question is I have sumary worksheet that take the data from
another worksheet, both are in the same Excel file, I would like to know if

I have written an Excel spreadsheet that has a list of formulae. The
formulae perform array calculations on a 10 by 12 matrix. A formula is chosen
by the user. The spreadsheet calculates the formula using a vba function like
Function EVAL2(R)

The same event handler for two CommandBar buttons
I add custom command
There are who similar XLA AddIns which add commandbars. The names of
commandbars are different and are formed from the name of the corresponding

How can I disable Copy-command in a sheet (or whole workbook). I have a
protected sheet that includes hidden columns (data which users are not
allowed to see), but if you copy the area to a new sheet, then all hidden
data become visible.

On excel worksheet I've got many links to other files and everytime I open
my file I get a msgbox asking to wheter I want to update or not. Is it
possible to avoid that message thru vba (I know that If I go to
Edit->Links->Startup Prompt I can remove this message) ?

I have an Excel form that contains a tab control. In the various tabs of the
tab control, I have text boxes that I want to be able to tab through
consecutively, when the user hits the tab key.  I have yet to figure out how
to set the taborder of these controls on a tab control.

My problem is when i enter a number into a cell i want a formula to be
inserted underneath this cell.  The formula will entered that number of
times.  My formula is
2*3.14*(A1+B1)/2

I'm pretty much a newbie when it comes to programming. I have written
a program for my work which has been used for months and produces what
it needs to and all that but I have a question...
Whilst programming it I noticed a couple of things which I thought

I wish to send a spreadsheet to colleagues with a custom toolbar attached.  
Is this possible, or do I have to load the toolbar onto individual machines.  
I can vaguely remember reading that toolbars can be created by vba, that is a
possible solution, but as the number of users of ...

I have two arrays that contain data that I am using for correlations.
The two arrays are dynamic (part of a larer data set) Each array will
ahve a different number of missing values. The two arrays are a time
series, the position in the array is related to specific time stamp. I