View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
baj baj is offline
external usenet poster
 
Posts: 24
Default data sort and protect sheet

Hi,

A possibility is hiding the sheet (when you're ready you also have to
protect the complete project so nobody can get to that hidden
unprotected sheet) without locking the actual cells.
In the visible part of your project you keep a sheet that is directly
linked to the hidden sheet... you have to protect this visible sheet,
it acts as a mirror ("paste special") for the actual working sheet in
the background.

Try & experiment... it works

Bye
Baj