hyperlink a cell to another worksheet of same book

[Ani]

Hi,
I have two questions...

Im trying to do a hyperlink from my MENU worksheet, that contains dates,
(all mondays) and so, I've done a special worksheet for every monday...

this is what i've done..
1. copy my first date 07-SEPT-09
2. go to the sheet named 1 (where I want to be tranfered when I click
07-SEPT-09)
3. Paste Special, Paste Link
4. go back to the MENU WORKSHEET, write an = sign at the beggining of the cell

and that's all I can do, I've tried to change the name thinking tha it might
be something with the date, but It just keeps saying error!

and my other question is..
is there a another way of unlocking a book if I've already tried by
selecting each sheet and unprotect them, but I still can't?????

 

[JLatham]

Choose the cell with the date in it. From the Excel menu use:
Insert --> Hyperlink
Then choose the "Place in this document" option and simply enter the cell
address to go to where it asks for one and identify the sheet you want to go
to. click [OK]

You didn't say what is happening when you try to unprotect the sheets in the
book? If it is asking for a password, you need to know it/them. If it is
the workbook that's protected from changes you need to unprotect the workbook
itself rather than trying to unlock individual worksheets. The option to
unprotect the workbook is in the same drop down list with unprotect sheets
(pre-Excel 2007).

This link should help with your unlocking problem if it is due to passwords
for either the worksheets or workbook:
http://www.straxx.com/excel/password.html