My previous question was fully answered and is located here:
However I have encountered two problems which were not part of my initial question so here they are:
1) How does the code get modified to unhide the chart tab? In the attached example for number 7, the chart is hidden, but an error occurs when you click on the appropriate cell.
2) When a range is selected (click and drag), an error occurs and prompts for debugging.
What needs to be changed in the attached VBA code Multiple-Chart-Link-Example.xlsm
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo errMsg
If Not Intersect(Target, Range("B31:K31")) Is Nothing Then
If InStr(1, Target.Value, "Sign") Then
strMsg = "There is no chart named '" & Target.Value & "'."
intMsg = MsgBox(strMsg, vbExclamation, "Chart Not Found")