I have a macro assigned to a cell that executes once clicked on. The macro involves SAP scripting, which if ever interrupted (via CTRL+DEL+ALT), also causes my previously clickable cell to stop working.
I can run the macro via Developer yet the cell is not working. Note that the code provided below is pasted in the sheet where the clickable cell is, not in ThisWorkbook.
Option Explicit Private Sub Worksheet_SelectionChange(ByVal target As Range) If Selection.CountLarge = 1 Then If Not Intersect(target, Range("A10")) Is Nothing Then Call FolderPicker End If End Sub
Any ideas what might be causing the issue?