I want to restrict from being able to sort by current selection only.

[RobertALWilliams]

I'm using MS excel in Home and Student 2013. I have setup a database that volunteers are going to add to. They will need to sort it on occasion. I want to make sure that nobody accidently sorts it only by a single column. We have no need to ever sort by one column only and am concerned that some volunteer will click on "Continue with the current selection" when the sort warning pops up. Is there a way to setup the file or excel in general to disable the choice of "continue with the current selection"?

 

[pbornemeier]

I could not find a way to do that using VBA, but if you convert that data to a table that will force sorts to use the entire table.