E
Electra
Hi,
My company likes to document every workbook by placing in cell A1 of
the first sheet in the workbook the workbook name and directory, and
the date the workbook was last saved. This is to be done before any
sheet is printed. The point is to have this infomation correct on all
hard copies of a workbook. This is used as a form of version control.
This information is traditionally typed/modified just before printing
by the person creating or updating the workbook. The problem with
this is that people often forget to update this info if the workbook
is updated/modified or if the workbook name is changed
altogether(file>save as).
I have been investigating formulas or other options to automate this
documentation. By reading past post for this group I learned about
the CELL and INFO functions for getting the book name and location
into a cell but these are not going to work for me because the person
would have to remember to do a manual recal (f9) or close and reopen
the book the get the info updated prior to printing and I didn't want
the solution I am up with to be person dependent.
The workbooks here are evenually published so because of publication
style rules we have to follow usings the special codes avaiable in
Excel header/footer area are not an option.
Any other ideas/suggestions?
My company likes to document every workbook by placing in cell A1 of
the first sheet in the workbook the workbook name and directory, and
the date the workbook was last saved. This is to be done before any
sheet is printed. The point is to have this infomation correct on all
hard copies of a workbook. This is used as a form of version control.
This information is traditionally typed/modified just before printing
by the person creating or updating the workbook. The problem with
this is that people often forget to update this info if the workbook
is updated/modified or if the workbook name is changed
altogether(file>save as).
I have been investigating formulas or other options to automate this
documentation. By reading past post for this group I learned about
the CELL and INFO functions for getting the book name and location
into a cell but these are not going to work for me because the person
would have to remember to do a manual recal (f9) or close and reopen
the book the get the info updated prior to printing and I didn't want
the solution I am up with to be person dependent.
The workbooks here are evenually published so because of publication
style rules we have to follow usings the special codes avaiable in
Excel header/footer area are not an option.
Any other ideas/suggestions?