Hi

I am using this macro (which I found on this site) and it is working a treat - my problem is that on my worksheet I have numerous unlocked cells & users want to be able to Sort & Filter on these columns.
Although I have allowed that, it doesn't work.
When you use the sort ascending buttons etc, it tells you that you can't as the sheet is protected.

I don't want users to know the password (otherwise what would be the point of puting one one)

I see from searching online that this seems to be a glitch in Excel 2010 - ANy ideas as to how I an get round this?

Thanks


Please Login or Register  to view this content.