It sounds like you didn't change the code to remove the lines that tried to
unprotect the sheet (and reprotect the sheet???).



Simon Lloyd wrote:

Hi all,

I have a workbook that when closed all the data in a named range is
sorted by date in ascending order, however when i tried to share the
workbook closing any open copy caused an error "Method of unprotect
class failed" but i only have one sheet in the workbook locked and its
not the sheet that is being sorted, i removed protection from the sheet
and still get the same error, Any ideas?

Simon.

--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=394485

--

Dave Peterson