Microsoft Office Forums Template for Noting Sheet.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2009, 05:15 AM
Goldenbird Goldenbird is offline Template for Noting Sheet. Windows XP Template for Noting Sheet. Office 2007
Novice
Template for Noting Sheet.
 
Join Date: May 2009
Posts: 7
Goldenbird is on a distinguished road
Default Template for Noting Sheet.


I want to develop a template for Noting Sheet which should repeat in all pages. I want that when I put Left Margin Page Border and Upper Page Border then both the lines should cross each other at their intersection point at extreme start of page. I also want to know how to make a frame or text typed in left margin portion repeat in all pages.
I have also attached a sample file for your easy understanding. The page depicted should be repeated in all pages to make template. Please tell me also how to protect the template contents i.e. in header and left margin to be not edited by any other person.
Attached Files
File Type: doc Noting.doc (60.0 KB, 19 views)
Reply With Quote
  #2  
Old 05-23-2009, 04:27 AM
Goldenbird Goldenbird is offline Template for Noting Sheet. Windows XP Template for Noting Sheet. Office 2007
Novice
Template for Noting Sheet.
 
Join Date: May 2009
Posts: 7
Goldenbird is on a distinguished road
Default

Much Shocking. No one has replied anything. I newly joined this forum with a very good hope to resolve my queries.
Reply With Quote
  #3  
Old 05-23-2009, 07:29 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Template for Noting Sheet. Template for Noting Sheet. Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

To be honest, I'm not quite sure what it is you want, but I'll give it a go:

  • Create your design (don't worry about the margins at the moment - JUST the design)
  • Select all (Ctrl+A)
  • Cut (Ctrl+X)
  • View > Headers and Footers
  • Paste the design into the header and rearrange as needed
  • Exit the Headers and Footers
  • Change the margins to suit
  • Save As ... > Template
  • DONE
Now you have your design on all pages, as a template, so that it will create a new document every time AND the design is unchangeable except to those who know about headers and footers!

Is that what you were looking for?
Reply With Quote
  #4  
Old 05-23-2009, 05:20 PM
zyzzyva57 zyzzyva57 is offline Template for Noting Sheet. Windows 7 32bit Template for Noting Sheet. Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 356
zyzzyva57 is on a distinguished road
Default To Big_Fat

For me, it is that darn TextBox on the side as I understood he wants repeated also

I could only get it to do this with Copy & Paste

I don't think you can just protect the Header (or Footer)
Reply With Quote
  #5  
Old 05-24-2009, 02:18 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Template for Noting Sheet. Template for Noting Sheet. Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

If you put EVERYTHING from the design in the Header, then you can resize the left margin and it becomes like a Watermark and is considered to be BEHIND the text by Word.

You don't need to protect it - it's seen as being on a different layer, so can't be typed over by accident.

I create my stationary this way and it has elements at the top, left and bottom of the page. All it takes is resizing the margins so that the text doesn't go over the image (though it won't make any difference if that's what you want it to do, it won't alter the design as it is on a different layer.)

Actually - if you wanted the box to be typed in, but you didn't want people to be able to edit the design - then you could place it in the Header as above, then using the 'Forms' toolbar, you could place a frame round it and change the text direction before adding text fields in the correct places - then the info could be filled in, while protecting the design!


And FYI zyzzyva57 - It's BIRD, not BIG! though you're not far from the truth - LOL!
Reply With Quote
  #6  
Old 05-24-2009, 02:55 AM
zyzzyva57 zyzzyva57 is offline Template for Noting Sheet. Windows 7 32bit Template for Noting Sheet. Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 356
zyzzyva57 is on a distinguished road
Default

I would love seeing your point in an example

Could I prevail upon you to post an example, particularly how to handle that TextBox on the left he wants on the left on every page after page 1?
Reply With Quote
  #7  
Old 05-24-2009, 04:11 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Template for Noting Sheet. Template for Noting Sheet. Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

'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!
Attached Files
File Type: doc Noting2.doc (56.5 KB, 11 views)
File Type: doc Noting3.doc (57.5 KB, 3 views)
File Type: doc Noting4.doc (56.0 KB, 4 views)
Reply With Quote
  #8  
Old 05-24-2009, 04:59 AM
zyzzyva57 zyzzyva57 is offline Template for Noting Sheet. Windows 7 32bit Template for Noting Sheet. Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 356
zyzzyva57 is on a distinguished road
Default

Thanks for the actual examples...
Reply With Quote
  #9  
Old 05-25-2009, 05:48 AM
Goldenbird Goldenbird is offline Template for Noting Sheet. Windows XP Template for Noting Sheet. Office 2007
Novice
Template for Noting Sheet.
 
Join Date: May 2009
Posts: 7
Goldenbird is on a distinguished road
Default

Thanks BirdFat and zyzzyva57 for your valuable support. I will go through it and respond for my further queries, if needed.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Template for Noting Sheet. 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
Template for Noting Sheet. Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM


All times are GMT -7. The time now is 01:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft