Hello - I have a problem with my Excel spreadsheet. I am unable to filter 'A to Z' in column G, when the spreadsheet is protected (works OK when not protected). The attachment shows the error code, and one of the macros showing the coding I've used to protect the sheets. You will see that I have already ticked 'sort' and 'autofilter'. Would you have any ideas please as to what I am doing wrong? Thank you.
Solved by G. A. in 23 mins