VBA to Formula?

[chef]

Probably a long shot but I though I would ask the experts or at least get the clarification of not possible.
I have used this code in various iterations for years and it works great for users to click on a value and automatically open up another workbook with the value in A1

My organisation has now disabled all macros on the back of microsoft 365 policy/guidance and I cannot use vba/macro now under any circumstance.
I am trying to have a user click on any value in a sheet called "Emp" and open up a sheet called "six" with the value chosen in cell A1.
I am assuming this cannot be achieved by formula solution, but thought I would ask just in case.

Whole disabling VBA is a real pain and feel such a backward step in 2023.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("C8:C180")) Is Nothing Then
Sheets("Six").Range("A1").Value = Target.Value
Sheets("Six").Activate
End If
End Sub

regards
Ian

 

[Fluff]

I am assuming this cannot be achieved by formula solution

You assumption is correct.