View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George Tattam
 
Posts: n/a
Default Macro fails when worksheet protected

I have a worksheet with a very simple macro which sorts a range of data on
the last column in the range.The macro runs fine when the worksheet is
unprotected but fails when protected. The error message is "Sort method of
range class failed". I have made sure all the cells in the range are
unlocked.I am running on Windows 2000.Any Ideas?