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????? |
hyperlink a cell to another worksheet of same book
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 "Ani" wrote: 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????? |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com