View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pivot Table/Query  Pivot Table/Query is offline
external usenet poster
 
Posts: 8
Default Verify protection status within a macro

I have a sheet that is kept protected unless it is time for data entry. I
would like to run a macro that checks for protection status, unprotect if
needed, then sorts, then returns the sheet to the protection status (i.e. if
not protected, leave unprotected, if protected, reprotect).

Help?