Disallow sorting of data.

[Guest]

Hi

I would like to disallow sorting of data in a worksheet as we have lots of
hidden data that will get messed up.

Could anyone help me with the code to create a simple message box explaining
that no data sorting can be achieved and then, once the user has closed the
message box, not allow the sort itself. Ideally, I would like the message
box to appear when the user clicks on "Data - Sort" in the menu bar on Excel.

Many thanks and Happy New Year to everyone.

Malcolm

 

[Tom Ogilvy]

If you have xl2002 or later, this should be an option under Tools=>
Protection =>Worksheet.

In earlier versions, I believe sorting is not an option for a protected
sheet (you can unlock cells you want to allow to be edited).

 

[Guest]

Thanks Tom

Problem solved.......I thought it would be harder than that.

Regards

Malcolm