Hi
I was wondering if anyone as a solution for this one. I have excel 2007 and a worksheet where I have two columns unlocked, and the rest of the columns are locked, and protected. What I need is a way to easily sort & filter the locked columns. Can anyone help?
Thanks
Dave
see if this helps u
http://excelribbon.tips.net/T000137_...orksheets.html
Only if "Sort" and "Use autofilter" were specifically allowed by whoever protected the sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for the reply Jayajay I have tried that website and their solution doesn't work.
Hi Glenn I was the one who protected the sheet and I selected Sort and Use Autofilter and it didn't work. it allows me to ctrl-f and find items but not sort or filter.
Can you post your sheet? If not, can you mock up a small sample to test?
Yes I can please find the sheet attached.
Take a look at this... at least it provides an explanation and possibly lets you find a way forward.
http://blog.softartisans.com/2013/10...ed-worksheets/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks