I have an excel file that will be shared by a couple of dozzen people. In
this file I need to have a floating command bar &/or buttons. I have tried
creating a custom toolbar and it works great for my computer but does not
show up for anyone else.

I am getting a error.
Run time error 9 on this line of code ( Windows(hirename).Activate ) I
am not able to understand it i also tried alternative code
wookbooks("Hrining Plan.xls").Activate but it is also not working.

I checked lots of posts but have not been able to find a solution for
my looping problem.  Hope someone can help.  I have 8 comboboxes on a
worksheet sheet and I want to reset the listindex on each one to 0.
Here's the code I used:

What i want to do is when someone opens the excell file it asks them for
their card number. When they click okay it filters column A in the "expense"
tab just the same way if you auto filtered and used the drop down list.
The only thing is i dont want it to allow them to filter ...

Would anyone know what the formula should be for this below
=sum(a1+a2)/abs(a1)
If I want to use a conditional statement
If a1=0 need the result to be 100%,

I have a worksheet where the data is laid out as in Worksheet 1,
below--I have data values (SomeValue) for county locations that
changes every hour.  I want to populate a second worksheet that has
the data selected by specific date and hour, and matching it to the

Hi all, i have a string variable with the path that i retrieved my file from
and i need to save the file after manipulation to the same path, just with a
"ZA_" in front of the file name. e.g.
Get:

I have many people using the file. Each person only needs a page worth of
information. I need a Macro to print curent page only.
I am hoping to have a macro that looks at what pape I am on and will print
the specific page. This way I do not need to make 97 buttons for printing.

Have the following that creates a text file. Problem it does use th entire
sheet that has data. Is it possible to have it only use those rows that are
complete. Here is what I've got.
Thanks to all

I am putting together a program to help me estimate the cost of
various metal parts. One variable is the material cost. The parts are
stamped from a sheet. I know how many parts one sheet will yield
(D25). I know the cost of one sheet (B26). Here's my dilemma; I need

I have this code, which someone provided me.
(…)
NewWS.Cells(xx% + 1, 2).Value = Sheets(xx%).Range("c271").Value
(…)

I have a Worksheet with 36 images all them having a name.
I also have a button that run clicked runs the Macro "Play". And I
have the following code:
Private Sub Workbook_Open()

I'm working in Excel 2003.  I've created a form containing a 4 column list
box.  The data for the list box comes from an inventory sheet.  Columns 2 and
3 of the inventory sheet are times (starting and ending).  On the sheet I've
formatted these columns in a custom format to show ...

I am wondering if I could get some help or suggestions on how do do a
particular type of task.
The problem is that I don't know how to even google what I am trying
to ask because I am sure my question is not new.

I have a UserForm with a Multipage Control (mpgPaint).  Each Page is Named
pgColor1, pgColor2, pgColor3, pgColor4, pgColor5, & pgColor6.  On each page
there are two checkboxes named chk1stSurfaceP1 & chk2ndSurfaceP1 (the number
1 represents what page it is on).  How can I cycle ...