Hi I am trying to run some macros in a protected sheet.
I believe using the UserInterFaceOnly:=True method will allow this and i have it in my Workbook_Open macro.
But a simple operation of copying a relative formula does not work.
Setup code:
Private Sub Workbook_Open()
Dim ws As Worksheet...