View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_63_] dominicb[_63_] is offline
external usenet poster
 
Posts: 1
Default Is this possible?


Good afternoon Neb

This should certainly be possible. Put this line before the sort
routine:

ActiveSheet.Unprotect Password:="DSKM"

and this line after the sort routine:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True, Password:="DSKM"

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=388414