Thread
:
filter on a protected sheet
View Single Post
#
2
Posted to microsoft.public.excel.setup
Nick Hodge
external usenet poster
Posts: 1,173
filter on a protected sheet
In XL XP (2002) on (I Think), you have the ability to allow filtering in the
worksheet protection dialog
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"peter" wrote in message
ups.com...
I have a sheet on which I need to protect some cells. I have it
filtered. Whenever I protect the sheet, I cannot click on the little
arrow to filter, even on cells that are not protected. What am I doing
wrong?
Thanks,
Peter
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge