Hyperlink a cell to a hidden worksheet

**jjin** · 01-08-2013, 01:53 AM

Hi everyone,

Is it really impossible to hyperlink a cell to a hidden worksheet?

I have two worksheets: Vehicle and House.

I want to hyperlink a cell in worksheet 'Vehicle' to the 'House' worksheet in the same workbook.

For example, if i double click a cell which is hyperlinked to a hidden worksheet ('House' in my workbook), it unhide the hidden worksheet and when I click a cell in the hidden worksheet, then I can again hide the worksheet.

Can anyone please help me to resolve this quiery ASAP?

Cheers,

**jraj1106** · 01-08-2013, 02:17 AM

Hi

Create Hyperlinks for the text on both the sheets. In sheet "vehicle", create the link to sheet "house" and in sheet "house" create a link to "vehicle" sheet.

Please Login or Register  to view this content.

**jjin** · 01-08-2013, 05:41 AM

Hi jraj1106.

I used your code to my Master workbook, then the following error message pop up and it freeze all the fomulas used in the workbook:
Run-time error '1004'
Method 'OLEObjects' of '_worksheet' failed.

When I click to debug the error, it highlight the the following statement from VBA code used in my worksheet
'Set cboTemp = ws.OLEObjects("BMLIST")'

See the code used on my worksheet below:

Please Login or Register  to view this content.

Any idea? This drives me crazy now.

**jjin** · 01-08-2013, 07:38 AM

I think the question i asked above is totally irrelevant to my initial question. I will post this in a new thread. Thanks

**jraj1106** · 01-08-2013, 07:41 AM

Is the hyperlink part working for you?

**jjin** · 01-08-2013, 09:27 AM

Hi j

If I want to link another cell from the same worksheet (vehicle) to a thrid worksheet (Ship), can Iwrite a code as below?

Please Login or Register  to view this content.

Thanks.

**jraj1106** · 01-08-2013, 09:35 AM

Yes.

Please Login or Register  to view this content.

**jjin** · 01-08-2013, 10:04 AM

Hi J,

When I click the cell in 'Vehicle' worksheet, it unhides both 'House' and 'Ship' worksheets.
Lets say cell A1 is hyperlinked to 'House' ws and
cell B2 is hyperlinked to 'Ship' worksheet.

When I click the cell A1, what happens is, it unhides both House and Ship worksheets.
Can I unhide only House worksheet by clicking the cell A1?

Cheers,