I am using the sub below to remove/restore toolbars.  This code also
removes the horizontal scroll bar.  What do I need to change to ensur
the horizontal toolbar is always visible?
Any help much appreciated.

I have some very weird problems, i must be missing something easy but i
have been at it for some time...
the following code is where I can isolate the diffrent behaviours
I assume that uncommenting solution 1 should result in the same

  Can someone please post n example of a call to Excel4 that registers
a class 2 Excel function a la VLookup? I am getting consistent
exceptions when I attempt to do this.
Kind Regards,

A1 has a hire date and I want to find the difference in days/years between A1
and a specific date (10/21/1994).
I'm not very familiar with date functions, can someone help me?

 Is it possible to add a function to the function wizard using VBA in an
XLA?  My xla adds a new function but I want the user to be able to click on
the "fx" button to see the wizard.
Cheers,

In VB, one can declare the last parameter of a function to be
"ParamArray", allowing the user to provide multiple parameters whic
are then packaged into an array and passed to the function as the las
argument.

I am having trouble removing items from a list box.  Here is my code:
Option explicit:
   Dim I As Integer
       If LstOLd.ListCount >= 1 Then

I just upgraded to Office 2003 and I had been using a script in Excell
2000 to import data from a ODBC connection. Everything worked fine in
2000 but in 2003, there seems to be a new option of "use trusted
connection", which seems to be turned on by default. Is there some

I have a text box called txtName on my form that a user input data.
want that data to popluate to a cell C7 in a worksheet called hrfrom
when the user clicks on the command button call cmdOK.  I tried th
code below but no luck. Any ideas??

is it possible to have a dynamic range that is filled with formulas an
expands/contracts depending on another range?
here's what i mean:
ranges x (data) and y (formulas) will be the same size. range x get

I have the following value:
"7D: Test Note"
I would like to remove the "7D: " from the above string.
How do I do this?

I have the following string:
"7D: test messages"
I would like to remove the value "7D: " from the string
How do I do this?

Hi, not sure if this is possible, but if it is then you are
genuis!!!!!!
We've got this system at work where we have to log in, though there i
a maximum of 40 users, so no more people can get in. However, if yo

Greetings MVPs!
I recorded a macro called Macro1. How can I rename it in VBA code? Many
thanks.

Small bit of help needed for 2 items.
I have a pivot table, which I want to have a user type in a value in cell
B3. 1) If the value is found in the drop down list of the pivot table on the
sheet, change the pivot table, 2) if not, display a message box saying so.