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
 
[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to Sharon.
Please use the newsgroup for further discussion.]

To insert a hyperlink to a cell that doesn't get messed up, create a
name for the cell and link to that cell. To create a name for a cell
click the cell then in the name area (at the extreme left of the
formula bar) enter some text which becomes the name. So, suppose you
have a header with the letter A just above all the names starting with
A. Then, click on the cell containing the A and enter a name of _A.
Similarly, where you have the B values starting, click header
containing the letter B, and enter a name of _B. Do the same for all
the letters.

Now, when you create the hyperlink, link to the name (i.e., _A, _B,
etc.) and not to the actual cell.

It isn't difficult to lock certain cells against editing. You need to
unlock all the cells where it is OK to make changes, and then lock the
worksheet. While it is pretty straigtforward, it's not the easiest to
explain. Look up 'protect cell' (w/o the quotes) in XL help and check
some of the topics.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top