ActiveSheet.Protect UserInterfaceOnly:=True allows me to protect sheets whilst still being able to write to cells from code.
But I cannot use code to put AutoFiltering on or off while sheet is protected for UserInterfaceOnly. How do I do this.
I have written a filter procedure that sets row hights to zero for rows that don't match the criteria but I would like to simply use Excels AutoFilter methods from the code while protection is on. I don't like turning protection on and off in code.
Thanks
But I cannot use code to put AutoFiltering on or off while sheet is protected for UserInterfaceOnly. How do I do this.
I have written a filter procedure that sets row hights to zero for rows that don't match the criteria but I would like to simply use Excels AutoFilter methods from the code while protection is on. I don't like turning protection on and off in code.
Thanks