Sorting Data before close in shared workbook?
 

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

Sorting Data before close in shared workbook?
 

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