Thread: how to sort in a protected worksheet.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Robnific Robnific is offline
external usenet poster
  
Posts: 22
Default how to sort in a protected worksheet.
Piece of Cake
open the page :
unprotect all
sort whatever you like
protect
show page
or
only protect page when you jump to another sheet.

Only need basic VBE code :)

www.allocator.nl
Home of James 2007

Reply With QuoteReply With Quote