Protected sheet becomes unprotected after sort...?

[richard.ca]

I am just trying out the protect sheet with UserInterFaceOnly option (running an ancient Excel 2000) to avoid having
to unprotect/protect every time my code wants to make a change on the sheet. Eg:

Sheets("sheet name").Protect "password", UserInterFaceOnly:=True

In general it seems to work fine but then I found something peculiar with sorting: the sheet somehow becomes
unprotected after I run the following sort code:

Range(my_range).CurrentRegion.Sort Key1:=Range(my_range), Order1:=xlAscending, header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

The sort function works normally and does not seem to produce any other unexpected side effects apart from leaving
the sheet unprotected. I assume this has to be a bug of some sort. Not really a huge issue since I can simply
reprotect the sheet after calling sort; the point is it shouldn't really be necessary.

Anyone else encountered this problem? I would imagine it has been fixed in later versions of Excel...

 

[DILIPandey]

Hi Richard,

Are you able to perform the sort in a protected sheet ?

Regards,
DILIPandey

 

[richard.ca]

Hi DILIPandey,

Yes, sort on the protected sheet works (as I would expect with the UserInterFaceOnly only option).
The only problem seems to be that the sheet is left unprotected after the sort function is called.

Regards,

Richard.