View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ANI ANI is offline
external usenet poster
 
Posts: 3
Default hyperlink a cell to another worksheet of same book


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?????