LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh Pivot table data in protect sheet Sumanthkaka Excel Discussion (Misc queries) 2 July 9th 09 11:16 AM
Protect Sheet Format when Data is Pasted Draino Excel Discussion (Misc queries) 1 September 21st 07 12:19 AM
Protect worksheet and still allow user to sort data J9 Excel Worksheet Functions 3 July 24th 06 02:08 AM
Sort Protect Sheet nvermilye Excel Discussion (Misc queries) 1 February 8th 06 05:28 PM
How to protect data in rows from being seperated during sort tired of finding my data scrambled Excel Discussion (Misc queries) 2 July 31st 05 09:25 PM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"