All of my spreadsheets have circular references, usually quite a few.  I just
got some code to force Automatic Calculation every time excel is opened by
way of embedding the code in personal.xls.  I'd also like to force iterations
for all spreadsheets through some vb in my ...

Hello. There are some templates we use to display report data in Excel
2003.  Whenever these open inside Excel there is no  X  (to close)
for that worksheet.  You can only close the whole Excel application
which is sometimes not desirable if you have multiple reports open.

Can I force Excel through a registry entry to set Tools | Options |
Calculations to "Automatic"?  I know that I can first open a spreadsheet
which is already set to Automatic and that all subsequently opened
spreadsheets will then be Automatic, but that is a pain.  I really want ...

I have Excel 2007 SP1. I autofilter my data and I copy the filtered rows. I
open another spreadsheet and paste the data. When I do this I get blank data.
It acts as if it pasted the data (it shows a highlighted area), but there is
no data. Any ideas?

I have sheet that I am wanting to enter Monday to Friday in cells manually.
I want the Interior.ColorIndex to be ruled by the actual day that it currently is.
I want to regulate that by today=() and format the value as dddd to give me the day.
How do I write the code to tell it that ...

I need help with a problem I'm having with a lookup. I was wondering
if I can lookup a text entry from a list based on 4 criteria. Cells
E3, E4, E5, and E6 will contain user selected values which would in
turn return a corresponding value from a list based on what's in the

using Excel 2002, is there a way to place a picture in a cell, then,
if the range the cell is in is sorted, have the picture move with the
cell?
Tonso

I'm writing a software program using .NET framework 2.0 with Excel 2007
installed on my dell laptop machine. I'm developing with Visual Studio 2005
using C#.
I have a method the first creates an instance of the Excel application:

Lets say I have the following weight plates for my home gym:
4x 10 kg
6x 2 kg
8x 1kg

Spreadsheet: 4.0 MB with 16,000 records and 60 columns created
originally in
2003, copied as values into new book and saved as 2007 file (the 2003
version

I'm trying to come up with a daily cost sheet.  What I've done so far
is develop a tab on the spreadsheet that has all the information, that
I want to retrieve.  Now, what I want to do is develop a  "summary
page" that retrieves information by date.  So, what I did was come up

I would like to insert an object (autoshape) in a Excel 2003.
If Value in a cell = UP then the autoshape UPARROW with blue color to
be displayed
If Value in a cell = DOWN then the autoshape DOWNARROW with blue color

If this is an idiotic question, please forgive...
I have spreadsheet with 2 tabs (worksheets).  The first tab has 15
columns and 350 rows of data.  The second tab is basically a printing
template.  It has 8 columns and 46 rows but it is mostly formatted to

How can I move directly control the cursor movement after pressing enter.  
For example, I would like my cursor movement to go something like this:
     CELL   MOVEMENT
      B5     DOWN

I created a macro, and used the Activesheet.Unprotect Password:="trip"
to protect it. But, I left out the : after "Password". When i tried to
run the macro i got a debug message. Now, "trip" will not unprotect my
sheet, and i have no idea how to get it unprotected. Can anypone