|
|
|
|
#1
05-24-2009, 04:11 AM
|
||||
|
||||
'Noting2.doc'
The box to the left has been placed into the Header and I have added two blank text fields in the main document window to aim people towards the correct areas – they can type in these boxes, while the design itself is protected by being in the Header. If the red lines are also supposed to be part of this, then the could also be part of the Header. If this is saved as a Template, then it negates a lot of the issues that were there in the first place. I don't think this is really ideal, as moving on to a new page will not take the fields with it, but then, do you need to have the number and date more than once in a document? Though I suppose you could write a quick bit of script to copy and paste the frame and fields if a new page is created - declare pg AS Range, then use a For Each statement to govern the copy paste operation?! 'Noting3.doc' If this was created as a full form, with sections that allowed for large input, etc. Then it could be protected, thus stopping any form of tampering, but not stopping people being able to enter data. - this would be my idea of the best approach, then you just open a new page from Template whenever you need it. 'Noting4.doc' The other way this could be done is to add the fields to the box INSIDE the Header – but that would depend on what the number and date are – you could create autonumbers relating to page numbers (if that’s what the number is!!) and place an autodate (unticking the ‘Automatically Update’ box) to create a ‘date on creation’ field! - this would be a better option than the first to me as it would then auto populate and negate user error - the only thing is, you would need to know what the reasons for the two fields are! 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Compare data in different columns in an Excel sheet
|
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
| Setting up Analysis Sheet when data does not exist, yet. | burnoutdetective | Excel | 0 | 10-13-2008 05:57 AM |
| sheet linking, sorting | nickbfe | Excel | 0 | 05-19-2006 11:00 AM |
|
Enter Number on any sheet one time only.
|
paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |
Office 2007
Hybrid Mode