Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hyperlinks to hidden worksheets

Hyperlinks to hidden worksheets

ResolvedVersion 2007

Mon 28 Oct 2013, 14:37 Delegate Jenny said...

Jenny has attended:
Excel Advanced course

Hyperlinks to hidden worksheets

I have set up hyperlinks to worksheets in the same workbook. These work until I hide the worksheet, is there anyway I can hide worksheets and the hyperlinks still work?

Mon 28 Oct 2013, 16:43 Trainer Andrew said...

RE: Hyperlinks to hidden worksheets

Hi Jenny

Thank you for your question. I regret to say that as I understand it the only way to make this work is to use the Visual Basic programming language to create your own instructions to show or hide the sheets.

I am sorry I couldn't be of more help.

Kind regards,
Andrew

Mon 4 Nov 2013: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Hyperlinks to hidden worksheets

Hyperlinks to hidden worksheets

RE: Hyperlinks to hidden worksheets

Excel articles

Excel tip:

Calculate difference between two times