Cable Forum - View Single Post

absthechatter · 30-11-2006, 13:30

Can someone help me with an Excel problem? I have a spreadsheet that is protected in some columns but not in others. I also have an auto filter on so certain catagories can be selected. When I protect the sheet, I can fill in the columns I have unlocked, but cannot use the filter. Is there anyway I can leave columns protected for input but still be able to use filter when protected?

Many thanks

Abs

---------- Post added at 14:30 ---------- Previous post was at 13:44 ----------

Sorry, should have said, I know I can do it on Office 2002 and above, it's whether I can do it on older versions, which unfortunately we have at work!!

Abs

30-11-2006, 13:30	#1
absthechatter Inactive Join Date: Dec 2004 Posts: 310	Excel question Can someone help me with an Excel problem? I have a spreadsheet that is protected in some columns but not in others. I also have an auto filter on so certain catagories can be selected. When I protect the sheet, I can fill in the columns I have unlocked, but cannot use the filter. Is there anyway I can leave columns protected for input but still be able to use filter when protected? Many thanks Abs ---------- Post added at 14:30 ---------- Previous post was at 13:44 ---------- Sorry, should have said, I know I can do it on Office 2002 and above, it's whether I can do it on older versions, which unfortunately we have at work!! Abs