| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a "locked 'top text'" in a document?
I try to insert a "locked 'top text'" in a document that contains 5 pages.
The doucument is used and edited in my company on a daily basis, but I want to ensure that the "top text" remains the same. Can anyone help me how to make this happen? LTV, Norway |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I insert a "locked 'top text'" in a document?
Select Window menu, then Freeze Panes?
"LTV" wrote in message ... I try to insert a "locked 'top text'" in a document that contains 5 pages. The doucument is used and edited in my company on a daily basis, but I want to ensure that the "top text" remains the same. Can anyone help me how to make this happen? LTV, Norway |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I insert a "locked 'top text'" in a document?
you can unprotect all cells other than the top and then protect the sheet
or you can write an event macro which will make sure the top cells remain the same. "LTV" wrote: I try to insert a "locked 'top text'" in a document that contains 5 pages. The doucument is used and edited in my company on a daily basis, but I want to ensure that the "top text" remains the same. Can anyone help me how to make this happen? LTV, Norway |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Retrieving info from "child" to a "parent" document | Excel Discussion (Misc queries) | |||
| Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
| Document is locked by "" | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
