I always use a filename for my worksheet that defines the worksheet itself.
Say a student class record for subject "CEPS 361 2nd sem 2005-06 Hydraulics"
would have that excel name with an extension of .xls, i.e. "CEPS 361 2nd sem
2005-06 Hydraulics.xls". Now I want this subject name to appear on the class
record to identify that this class record is for that subject, and what I
would like to happen is that its time I change the name to another subject
(as I only copy an existing worksheet and rename it to another name for
another subject) it would also appear on the class record the new name of the
subject without physically editing the cell. I don't want to use a header or
a footer for this and I still do not know anything about macros. Is this
possible without using a header or a footer or even a macro? If it is may I
know how? Thanks.