The following code executes a macro based on the day of the week. It
works well. Now I need some help modifying it so that only runs ONLY
the first time it is opened each day.   Many users can access this
shared workbook and the macros put in some default informaion that some

We are looking at upgrading from 2003 to 2007 at work.  Have have noticed
that the layout ie icons and menus are all different.
Is there anyway of changing the view to the way it looks in 2003?
regards

I'm not sure if what I'd like to do is possible, but hopefully someone
will be able to help me out.
I have an Excell 2003 workbook which contains various sheets. On one
sheet I have 3 charts that are derived from data in the other sheets.

I have copied and pasted some text from a webpage, but some of the text is an
hyperlink to another webpage.
How can I change this to be just text?
I have copied and paste value but it did not work?

I have this code:
With ActiveSheet
  LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
  .Range("A3:A44").AutoFill Destination:=.Range("A3:A" & LastRow), _

Background:
I have 4 sheets in the workbook. One sheet is named TOTALS. The other 3
sheets will have different names that change each month.
Scenario:

I'm working on a workbook that has many formulas spread over 5 or 6
worksheets.  In an attempt to tidy things up, I've been trying to
convert a lot of the references to names, using insert | name | apply.
This only seems to works for me if the formula and the reference are on

after enering data how can I press enter to move to a specific cell?

I have this code:
With ActiveSheet
  LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
  .Range("A3:A44").AutoFill Destination:=.Range("A3:A" & LastRow), _

Getting my "feet wet" in some VBA. (it's about time!)
I'm playing around trying to do this based on another post.
I have this formula in cell E1:
=IF(ISNA(MATCH(D1,A1:A100,0)),"$A$1",ADDRESS(MAX((A1:A100=D1)*(ROW(A1:A100))),1))

How is it possible to move a complete folder from a cd.  The thing I cant
understand is people have different drive letters for their cd-rom etc.  So
is it possible to have it check the drive letter and then save the directory
from the cd to the c:\21Legs

I need to pull in the update_date from approx 60 files and need some
help in building an 'updateable' macro.  I'm familiar with the
FileDateTime methodology, but only in a static application -- ie, the
file names don't change.  Let me explain the data format:

I need a little help with this code please
I am trying to save using a macro to the directory c:\21 Legs
using the cell Sheet4.Range("a18").Value
How do I do this ?

Hi gang.
I am stuck on asomething that has become quite curly.  Yet it seems
like it should be 'obvious'.     I
The VBA code itself: "Highlight( )" works great.  Except in the

Help Required. I wish to Change Validation list in the adjecent cell on
the Basis of Value in the Active Cell. I understand that I can achieve
this using a cell activate event and then putting a code to delete and
add a validation in the adjacent cell.