View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default

JMcG, you could have the macro unprotect the sheet, sort the info and then
protect the sheet
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JMcG" wrote in message
...
Using Excel 2003 but need to share the worksheet with Excel 2000 users.I
need
to be able to protect certain cells within the worksheet. A Macro is
set-up
to sort certain info within the worksheet using various filters. When the
sheet is protected the filters no longer work. Any help would be
appreciated.