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

RobertALWilliams

New Member
Joined
Nov 24, 2014
Messages
1
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"?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,848
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,659
Messages
5,524,147
Members
409,562
Latest member
meeranaskar

This Week's Hot Topics

Top