View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ElsiePOA ElsiePOA is offline
external usenet poster
 
Posts: 1
Default Password Protection


I have a sheet that is password protected. Is it possible to write a
macro that will un-protect the sheet automatically, sort it and
re-protect it, entering the password again automatically? And, if it
is possible to do that, how can I password protect the macro, so that
the user can't access the sheet protection password?


--
ElsiePOA


------------------------------------------------------------------------
ElsiePOA's Profile: http://www.excelforum.com/member.php...fo&userid=3901
View this thread: http://www.excelforum.com/showthread...hreadid=564433