Wed 6 Dec 2006, 16:11Delegate Ben said...
Ben has attended:
Excel Introduction course
Excel Intermediate course
Filename and date automatic update.
Is it possible to create a setting in an excel file (a scoring submission form) that will force the person opening and completing it to fill out one or more given cells, or better still the file name, in order to indicate who had amended the form and when?
(Like many web-based forms)
Ben
Thu 7 Dec 2006, 11:13Trainer Richard said...
RE: Filename and date automatic update.
You could se the file to Read-only, which would mean the person saving the file would need to specify a different file name. You could specifiy the format:
ie:
ScoreSubmissionForm-YYYY_MM_DD-YourName.xls
To make the file read-only, simply right click on the file in windows explorer, choose properties, and then tick the ReadOnly box.
