Jan 23 2018
07:07 AM
- last edited on
Jul 25 2018
09:44 AM
by
TechCommunityAP
Jan 23 2018
07:07 AM
- last edited on
Jul 25 2018
09:44 AM
by
TechCommunityAP
Good morning. Our firm concentrates on providing training for people with disabilities, and I have been developing Excel tools that allow visually impaired individuals to access spreadsheets using the JAWS add-on. I use hyperlinks to assist the user to navigate to various cells on the spreadsheet. There are charts (bar graphs) on the spreadsheet, and when the user clicks on the hyperlink the cursor moves to the cell address, which is behind the chart. A visually impaired user cannot see that there is a chart in front of the cell. Is there a way to hyperlink to the chart itself? Thanks.
Jan 23 2018 07:16 AM - edited Jan 23 2018 07:18 AM
Assuming you point each hyperlink to the top-left cell below each chart you could place this code in the ThisWorkbook module to have the chart floating with its top-left corenr on top of that cell selected:
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink) Dim oShp As Shape For Each oShp In Sh.Shapes If oShp.TopLeftCell.Address = Sh.Range(Target.SubAddress).Address Then oShp.Select Exit For End If Next End Sub
Jan 23 2018 07:25 AM
Hi Jan,
Thank you for the quick reply and solution. I must admit however that you have me at a disadvantage. I don't know what you mean by placing a code in the ThisWorkbook module. Would you be able to provide me with further guidance? Thanks.
Best,
Ed
Jan 23 2018 08:18 AM
Jan 23 2018 08:53 AM
Jan,
That worked! Thank you so much.
Best,
Ed