Hi,

At work we are currently making a new spread sheet set up to manage
figures etc (well we are testing it etc).

There are a number of different spread sheet files that are all the
same apart from each one having some rows at the top with different
info, the totals from them are all linked into a separate totals
sheet.

But the main files spread sheets all have the same info area in them
(ie same info in the cells size formatting etc) and have the info in
some cells protected (ie so they cant be accidently wiped out) (these
all have a grey cell fill) white cells are where the info is entered).

I know its possible to link cell info from one file to another but is
it possible to link the cell formatting from one file to another.

Ie so we have a master template with the info area which the other
files get the cell info, formulas and formatting from). (so that if we
needed to add, delete cells/info etc we would do it via the master and
the rest update from it.

The next one question is, is it possible to when an excel file is
opened excel pops up a message asking for a name or (if possible an
ID# which when entered it matches to a name and puts the name into a
certain cell).

Ie open the file, excel asks for User # - enter 12345 and 12345 is
linked/matched to Joe Bloggs and it auto enters it into the set cell.