Is it possible to open Workbook1 with macros allowed but then open Workbook2,
from within Workbook1, but with macros disabled? I really only am trying to
copy data from Workbook2 to Workbook1 and don't need the "Open workbook"
macro to run in Workbook2. It just really slows down ...

i have around 20 sheets each one has a following data
    A     B     C     D     E     F
1   5     6     7     8     9      abc
2   6     5     8     8     9      def

Hello -
I am trying to find the formula (or formulas) that will allow me to enter in
two dates and find the number of pro-rated vacation days one has, based on 20
per year.  

I am sure this is an easy one for the MVP's...I need to insert 5 rows after
each rowin a worksheet that has 70 rows.  Each Row currently has data, we
need to add data between each row.  Also, we need to do this for antoher
sheet that has a different number of rows than 70.

I have a stacked bar chart with two values and I want to add the data label
of the combined value.  I have only been able to add each individual number.  
Any ideas of how to get the totals.  I have the totals done in the
spreadsheet.

I our company we use widely excel spreadsheets with drawings on them. There
are used to describe some well configuration and other things.
Since some of our guys are using vista, we are start having problems.
When we (office xp, 2003) receive spreadsheets with drawings, everything ...

I'm keeping information regarding work sites in rows in a spreadsheet. The
information contains data & formula. There may be multiple rows per work
site. Rows belonging to a particular site are kept together, and sites are
seperated by a colored divider row.There is also a header ...

I want to clear all data entered into individual data cells but not the
formulas in other cells with out clearing each data cell one at a time.

Good Morning,
I have a macro that copies one page of data to another by pasting the
values. The original copy page also includes text boxes and clip art on it.  
I'm looking to only capture the Excel cell contents in the copy paste process

Am trying to subtract one date from another to get a calculated answer in
days, hours and mins.  One of the dates in question is start date of
08/06/2007 08:43 with a finish date of 21/11/2007 13:00.  Is their a cell
format avaible to display the answer as 166 (04:17) i.e. number ...

I cannot figure out if this is possible or not.
I have a workbook with 51 worksheets in it.  The first sheet is a Total
sheet and is supposed to show a summary of each of the other 50 worksheets.
So I need to figure out how to get cell A5 from Sheet2 to show up on the

Is it possible to do the following @ all.  I have a formula that
returns results from two different places used for review in a
meeting.  I want to show where data exists in the second spreadsheet
bring this into the cell formatted in Red.

I have a Target Value macro set to run automatically and clear a cell if it
finds the zero value. It works but not quite the way I was hoping.  
The Target Value is running on a page (“Front Page”) that is based on a set
of cells linked from another page (“Data Page”).  Once “Data ...

Is there anyway you can freeze the first worksheet tab so that it stays at
the beginning of the listed worksheets. (i.e. in a way similar to the freeze
pane function)