Hello
I am trying to cretae a code that protects my worksheets but allows users to edit ranges. I want the editable ranges to be 'Named Ranges' from the active sheet.
I have tried simply recording myslef doing this but cannot seem to make it work.
Any help would be appreciated.
Thanks
Nik
I am trying to cretae a code that protects my worksheets but allows users to edit ranges. I want the editable ranges to be 'Named Ranges' from the active sheet.
I have tried simply recording myslef doing this but cannot seem to make it work.
Any help would be appreciated.
Thanks
Nik