| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINK() FOR A SPECIFIC CELL IN A CLOSED WORK BOOK & SHORTCUT | Excel Discussion (Misc queries) | |||
| hyperlink to a cell in another worksheet | Excel Discussion (Misc queries) | |||
| hyperlink that are relavant to a work book not a computer | Excel Worksheet Functions | |||
| Maintaining a hyperlink to moved data within the work book | Excel Discussion (Misc queries) | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
Threaded Mode
