I've created custom command bars  in a 3 workbboks.  I wish to retain these
workbooks and command bar  but make copies of them for work sheet
alterations.  Structure and format will be the same so command bars/Buttons
can be retained with only changes to names etc used in the ...

I running a  vba script inside a workbook.  How do I get the complete
path to the workbook and name in which this script runs?
Thanks

I have the gotten the following VBA from previous post to insert and new line
- works great, but I want to be able to hide row (i) so people cannot insert
data into it. Is this possible? Thanks heaps in anticipation.
Public Sub ProcessData()

I have protect excel sheet1, which we have enter data in many column.
I have create another sheet2 for summery. here we have use 2 criteria like
Buyer and mode (ship or air)
its working fine.

How to find out the total minutes between to different times without date.

I have several texboxes on a userform. Each textbox should display value of a
cell. the problem I am having, is that everytime the userform is opened the
data on each texbox gets displayed only once. i am finding that the formula
on each cell is cleared.

How do I enter a formula that self calculates every time data is entered
such as in out and balance
in     out     bal
100            100

I have 136 pages in a workbook when i click the save button it takes 2 min.
to complete. Is there a way to set the pages it is to save ?

Hello...I have a code that keeps getting a runtime 1004 error. I beleive it
is because the string is too long. Anyone have any suggestions on how to
shorten the string or expand the default range? Here is my code....
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

I have created a new style and stored it in the start up template in Program
Files/Microsoft Office/Office11/XLSTART/BOOK.XLT. Before I saved it, I
checked the STYLE drop down box and it was there.
When I create a new workbook, the new style is not avaialble as I expected

I understand that this is more than likely a Datatel Colleague issue but I
wanted to post here before I paid to talk to their technical support.
When I run a Query no matter what OS (Vista or XP) or Office 2007 or 2003 I
receive an error that states:  

I have and IF statement with multiple TRUE/FALSE parameters. I am trying to
convert it onto a userform using option buttons. for example on my excel
sheet i have A1-A5 all false/true (with only 1 being true). How do I convert
this over to my userform using multiple option option ...

If for example I have the following formula:
=Sheet!$a1
and I want to copy it in the colums. I would like to have:
=Sheet!$a1      =Sheet!$a2       =Sheet!$a3... etc.

exel 07 - doesn't bring down drop box to download analysis tool pack excel

I am having a difficult time trying to resolve this issue.
I have a simple workbook, with a simple active x button. The onclick
subroutine for the button is very simple.
Private Sub CommandButton1_Click()