Hi;
I have built a little spreadsheet project form a club I am a member of. I
have one sheet of the Workbook password protected in order to make some
hidden columns in accessable to anyone other than executive members.  The

Hi all, I have a workbook with an auto_open macro which cycles through
all worksheets, selecting "A1" so that each of the 30+ sheets displays
in the top left position when opened.  Works perfectly except for the
whirring display to the user, as I cannot use

Hi All;
I think I am doing things the hard way.  It is taking me about 50 lines and
looks awfully hacky.  All suggestions gratefully received.  
I have a small data base (30-40 members of a local club).  I want the user

I am trying to find out why I am able to select a single cell Range in a
Macro but not a multi cell one. For example:    ActiveCell.Offset(-2,
Counter1).Select      This works. Single cell.
ActiveCell.Offset(-2, Counter1):ActiveCell.Offset(-1, Counter1).Select

Hi -
I have two workbooks in an application.
Book "One" opens before "Two". (a macro
does this.)

In an already working well VB6 written COM addin, in order to obtain that my
COM Add-in intercept WorkbookOpen event I added these lines to the
Connect.dsr code:
***

Hi;
I have a custom toolbar for my club project.  When I send the project to
another user using Excel 2000 the toolbar gets lost.  I am using OfficeXP.  
We both have WindowXP.

here is the file: http://www.mytempdir.com/935740
First sorry for my english....
I have this code to insert letter "E" in column N of a sheet GAF only if the
dates in column B of sheet GAF are into range DATAIN/DATAFIN

I have just upgraded to 2003 and don't know where to put my personal.xls, nor
my .xlb's?
In the 2002 version the personal.xls resided in the C:\Program
Files\Microsoft Office\Office 10\XLStart folder, and

First, I'm not sure if this is the correct newsgroup for this but I try...
I would like to use excel to reformat text in a musiclibrary.
All performers are located in a textfile like this:
Line 1: ADAMS, BRYAN (ENG) + DENVER, JOHN (USA) + JARRE, JEAN MICHELLE (FRA)

-I have 2,000 records in my sheet. Column A has my Model#, Col B has my List
Price, Col C has the Supplier Model#, Col D has the Supplier New List Price.
--I carry only 1,000 of the Supplier's items.  
---I want to run through Col C and find the matching record (if there is

i have userform in a module and the  userform contains textbox and
commmand box.
If (Not IsNumeric(TextBox1.Value)) Then
   response = MsgBox("Please provide acceptable Number", vbOKCancel,

Just out of curiousity / desire to learn, can someone explain to me what
Implements is useful for?
The way I read the example, variables were defined in one class, then two
classes that Implement that first class have to define all the properties to

is there an easy way to return the address of the min or max result? if it's a
lot of code, i'm not going to worry about it, it's not that important. but if
there's an easy way, i'd like to know.
thanks

Hi, can I modify the formula  =MATCH(A33,F7:F15,0)/2 so that it only
give whole number results. Eg not 1.5,2.5,3.5 but 1,2,3.
Regard Robert