Please help......

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Hi

I have managed to create hyperlinks,what I am doing is
trying to make an "address book" type thing, where at the
top of the page you have the alphabet, you click on "p"
and it takes you to the "p" section on the same page,
which works fine, except when I add lines, the hyperlink
of the "p" section doesn't move down, it stays where it
is. How can I make it move down and stay linked to the
top alphabet, when I add lines??

Is there a way where you can add data that cannot be
edited?? Such as "Surname", "Name", "Address" and stuff
like that. So if I send the document to someone, they
can't delete anything, but they can add things?? If you
know what I mean??

Please help if you can.

Regards
Shaz
 
Sharon,

Where the actual data starts, create a range name. For instance where P
starts, create a name called pSection referring to that point.

Then, change your Hyperlinks to reference Defined Names, not the range
address (it's on the same part of the Hyperlink dialog). This should keep
the things together.
 
As far as adding data that can't be edited, you can protect the cells and
the sheet and make the cells locked. That would work, but you would have to
unlock it when you want to change those cells. Alternately, you could use
DATA>VALIDATION and basically make it where nothing somebody enters will
meet the validation criteria. You know, make it like a password, where the
only thing they could enter which would be accepted is a string of
characters like "q3SFG48V". That would work also, but you would have to
turn that off, too, in order to enter *real* data there. This measures are
mostly to keep others from changing what you put in.
HTH
Richard Choate

Hi

I have managed to create hyperlinks,what I am doing is
trying to make an "address book" type thing, where at the
top of the page you have the alphabet, you click on "p"
and it takes you to the "p" section on the same page,
which works fine, except when I add lines, the hyperlink
of the "p" section doesn't move down, it stays where it
is. How can I make it move down and stay linked to the
top alphabet, when I add lines??

Is there a way where you can add data that cannot be
edited?? Such as "Surname", "Name", "Address" and stuff
like that. So if I send the document to someone, they
can't delete anything, but they can add things?? If you
know what I mean??

Please help if you can.

Regards
Shaz
 
Back
Top