View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tommy_gtr[_17_] tommy_gtr[_17_] is offline
external usenet poster
 
Posts: 1
Default data sort and protect sheet


hello,

I have a little problem, but maybe it's not so little, when I can't
find solution for it.

I wrote a macro, which sort my data in table, for example tha range of
my table is A 10: H 100 . Then I set up, which cell I want to protect,
of course the table, in which I want sort the data has unprotect cells.
and then I protect sheet, but when I run a macro, the debug dialog will
appear.

Can anyone help???

Thanks a lot ....

tommy


--
tommy_gtr
------------------------------------------------------------------------
tommy_gtr's Profile: http://www.excelforum.com/member.php...o&userid=26089
View this thread: http://www.excelforum.com/showthread...hreadid=478151