Hi Y'all

Just wondered if it is possible in excel to create on a sheet (call it say cover sheet) with links to sheets that I intend to hide as these sheets provide background data thats not neccessarily important, but on the cover sheet still have access to these via a hyperlink or such?

Thanks

dan

hi danlindley

It is easy enough to create a hyperlink to another sheet..

Insert > Hyperlink > "Place in this document"

You can then change the targeted place to a sheet name or defined range. Only problem is that this doesn't work if the sheet you are referring to is hidden.

You could use a macros maybe attached to a button or a cell to unhide a sheet and then to select a specific area on that sheet.. something like the below should work....

Sub Macro1()
'
' Macro1 Macro
'
Sheets("Sheet2").Visible = True
Sheets("Sheet2").Select
Range("A1").Select
End Sub

You would then need another button or macro to close the sheet and return to the original page. If you are unsure of macros there is a record button which is sometimes easier, it will record your actions and you can then adapt it to what you need.

Cheers.