Disable sorting buttons?

JugglerJAF

Active Member
Joined
Feb 17, 2002
Messages
269
Is it possible (in office 2013) to disable the "Sort A to Z" and "Sort Z to A" buttons (the ones that do the automatic sort), but still allow the user to sort using the main Sort button (the one that displays the Sort dialog box that allows you to choose columns, sort by values/colour etc., and specify ascending or descending).

The reason for the question is that a member of staff keeps managing to break data files by selecting part of the data and clicking the automatic sort button.

I still want to be able to sort data, just not using either of the buttons that apply the sort without showing you any of the sorting options being used.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,113,772
Messages
5,544,139
Members
410,595
Latest member
Tatum2020
Top