if you were wanting open another workbook as opposed to changing worksheets,
u can use workbooks.open method or workbook("sssss").select if the workbook
is already open


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Call tst
End Sub

Sub tst()
If ActiveCell.Address = ("$A$1") Then
Workbooks.Open Filename:= _
"C:\?????\???\CHORES.xls"
End If
End Sub

"Zoeletta" wrote:

To whom ever can help a stressed and confused Excell user,

I want to be able to double click on selected merged cells and have this
take me to another destination that contains more information. Both
spreadsheets have been developed and are in use now but it would make it
easier if this can be done. I

f anynoe can assist me here, I would be eternally grateful.

Cheers

Zoeletta