Hyperlink references cell in 'grouped' data

[dmacmillan]

Hello All,

I am using hyperlinks to assist users navigate a workbook. Certain hyperlinks are directed (land) on a cell reference that is part of 'grouped' data (i.e. Data/Outline/Group from Ribbon). It can be difficult to see the cell reference.

Is it possible to 'ungroup' the selection when the hyperlink is launched so the user can readily identify the cell reference.

Envisage a VBA Worksheet.Event - or similar - is required.

By way of background: the workbook I am developing is large (75Mb in '.xslb' format).

Many thanks for your consideration/assistance.

Regards,
David

 

[Jerry Sullivan]

Hi David, Are you using Hyperlink Objects or =HYPERLINK() function worksheet formulas?